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
Note: kutools for Excel 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.
- Then, go to the Kutools Tab, select the Content option, choose the Change Sign of Values option from the menu.
- It will open the Change Sign of Values Dialog Box.
- Operation – You need to select the Fix trailing negative signs option.
- Then, click the OK button to get the result as shown in the below image.
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.
- Then, go to the Kutools Tab, select the Content option, choose the Change Sign of Values option from the menu.
- It will display the Change Sign of Values Dialog Box.
- Operation – ** Here, you need to **select the Change all negative values to positive option.
- Finally, hit the OK button. It will change all the negative values in the range to positive values as shown in the below image.
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.
- On the Kutools Tab, select the Content option, choose the Change Sign of Values option from the menu.
- 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.
- You can see that all the selected positive numbers have been changed to negative numbers as shown in the below image.
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.
- Go to the Kutools Tab, select the Content option, choose the Change Sign of Values option from the menu.
- 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.
- Now, you will see all the signs of the selected values have been reversed as shown in the below image.
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.
- Go to the Kutools Tab, select the Content option, choose the Change Sign of Values option from the menu.
- 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.
- In the below image, you can see that the negative values in the selection have been changed to zeros.
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. Keep Learning!
Top comments (0)