How to Change the Signs of Numbers in Excel Office 365? – Quick Steps!!
Tags: changethesignsofnumb, kutoolsexceltutorial, kutools
Published: 2020-11-21 09:45:11

---
title: How to Change the Signs of Numbers in Excel Office 365? – Quick Steps!!
published: true
date: 2020-11-21 09:44:34 UTC
tags: ChangethesignsofNumb,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-change-the-signs-of-numbers-in-excel-office-365-quick-steps/
---

In this article, you will understand the steps to **Change the signs of Numbers in Excel Office 365** using **Kutools.** Let’s step into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Fix Trailing Negative Signs:

If you have a range of numbers that contain negative signs on the right of them and you want to put the negative signs from the right to left, you can easily fix it by doing the below steps.

- You need to **select the cells or ranges** that you want to fix trailing negative signs.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-37.png)<figcaption id="caption-attachment-17833">Select the range</figcaption>

- Then, go to the **Kutools Tab, select** the **Content** option, **choose** the **Change Sign**  **of Values** option from the menu.

![Select the Change Signs of Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Change-Signs-of-Values-option.png)<figcaption id="caption-attachment-17832">Select the Change Sign of Values option</figcaption>

- It will open the **Change Sign of Values Dialog Box**.
- **Operation –** You need to **select** the **Fix trailing negative signs** option.

![Change Sign of Values Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-36.png)<figcaption id="caption-attachment-17834">Change Sign of Values Dialog Box</figcaption>

- Then, **click** the **OK** button to get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-20.png)<figcaption id="caption-attachment-17835">Result</figcaption>

## Change All Negative Values to Positive:

To change the signs of numbers from negative to positive in Excel, do as below steps.

- First, you need to **select the range** that you want to convert as positive numbers.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-35.png)<figcaption id="caption-attachment-17836">Select the range</figcaption>

- Then, go to the **Kutools Tab, select** the **Content** option, **choose** the **Change Sign**  **of Values** option from the menu.

![Select the Change Signs of Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Change-Signs-of-Values-option.png)<figcaption id="caption-attachment-17832">Select the Change Sign of Values option</figcaption>

- It will display the **Change Sign of Values Dialog Box**.
- **Operation – ** Here, you need to **select** the **Change all negative values to positive** option.

![Change Sign of Values Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-31.png)<figcaption id="caption-attachment-17837">Change Sign of Values Dialog Box</figcaption>

- Finally, hit the **OK** button. It will change all the negative values in the range to positive values as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-26.png)<figcaption id="caption-attachment-17838">Result</figcaption>

## Steps to Change All Positive Values to Negative:

Here are the steps to convert all positive numbers to negative numbers in the Excel spreadsheet.

- You need to **select the range** that you want to change.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-24.png)<figcaption id="caption-attachment-17839">Input Range</figcaption>

- On the **Kutools Tab, select** the **Content** option, **choose** the **Change Sign**  **of Values** option from the menu.

![Select the Change Signs of Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Change-Signs-of-Values-option.png)<figcaption id="caption-attachment-17832">Select the Change Sign of Values option</figcaption>

- It will display the **Change Sign of Values Dialog Box**.
- **Operation – ** In this section, you need to **select** the **Change all positive values to negative** option.
- At last, **click** the **OK** button to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-22.png)<figcaption id="caption-attachment-17840">Click the OK button</figcaption>

- You can see that all the selected positive numbers have been changed to negative numbers as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-21.png)<figcaption id="caption-attachment-17841">Output</figcaption>

## Reverse the Sign of All Values:

If you have a range with both negative and positive values and you want to reverse the sign of each value, then do as below steps.

- First, you need to **select the range** that you want to change.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-19.png)<figcaption id="caption-attachment-17842">Input Range</figcaption>

- Go to the **Kutools Tab, select** the **Content** option, **choose** the **Change Sign**  **of Values** option from the menu.

![Select the Change Signs of Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Change-Signs-of-Values-option.png)<figcaption id="caption-attachment-17832">Select the Change Sign of Values option</figcaption>

- It will display the **Change Sign of Values Dialog Box**.
- **Operation – ** You need to **select** the **Reverse the sign**  **of all values** option.
- After that, you need to **click** the **OK** button to close the dialog box and get the result.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-16.png)<figcaption id="caption-attachment-17843">Click OK button</figcaption>

- Now, you will see all the signs of the selected values have been reversed as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-11.png)<figcaption id="caption-attachment-17844">Result</figcaption>

## Change All Negative Values to Zeros:

To change all the negative values to zeros, follow the below steps.

- You need to **select the range** that you want to change.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-11.png)<figcaption id="caption-attachment-17845">Select the range</figcaption>

- Go to the **Kutools Tab, select** the **Content** option, **choose** the **Change Sign**  **of Values** option from the menu.

![Select the Change Signs of Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Change-Signs-of-Values-option.png)<figcaption id="caption-attachment-17832">Select the Change Sign of Values option</figcaption>

- It will display the **Change Sign of Values Dialog Box**.
- **Operation – ** In this section, you need to **select** the **Change all negative value to zero** option.
- Finally, you need to **click** the **OK** button to get the output.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-8.png)<figcaption id="caption-attachment-17846">Click OK button</figcaption>

- In the below image, you can see that the negative values in the selection have been changed to zeros.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-8.png)<figcaption id="caption-attachment-17847">Output</figcaption>

## Conclusion:

From this article, you can easily understand the steps to **Change the signs of Numbers in Excel Office 365** using **Kutools. ** Leave your valuable **queries/suggestions** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Show or Display All Cell Formulas in Excel Office 365?](https://geekexcel.com/how-to-show-or-display-all-cell-formulas-in-excel-office-365/)
- [How to Change Date Format in Excel Office 365? – {Simple Ways}](https://geekexcel.com/how-to-change-date-format-in-excel-office-365-simple-ways/)