Quickly change sign of numbers in Excel
If you want to change sign of a number or value from positive to negative, and vice versa, you may need to manually add or remove the negative sign one by one, or you can use a formula for doing so. Excel does not support with an option to quickly change sign of values or fix trailing negative signs. With Kutools for Excel’s Change Sign of Values tool, you can quickly apply the following operations to a range. Demo
- Fix trailing negative signs: Change the negative sign from the right of a value to the left;
- Change all negative values to positive;
- Change all positive values to negative;
- Reverse the sign of all values: Make all positive values to negative, or all negative values to positive.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10. Read more...
Classic Menu for Office: Bring Classic Menus and Toolbars of Office 2003/XP/2000 Back to Office 2007, 2010 and 2013. Read more...
Click Kutools >> Content Converter >> Change Sign of Values. See screenshots:
1. Select the cells or ranges you want to change sign;
2. Choose an option from the Operation;
3. Click OK or Apply. (If you click OK, the dialog box will close; if you click Apply, the dialog box will not close, and you can continue to do other options.)
For example: Supposing I have a range of numbers which contain negative signs on the right of them, and now I want to put the negative signs from the right of numbers to the left. I can quickly finish it as follows:
- Select the ranges that you want to use.
- In the Change Sign of Values dialog box, select Fix trailing negative signs from the Operation.
- Then click OK. The negative signs of selected numbers have been removed from right to left. See screenshots:
This is only one application of this utility, also you can change all negative values to positive, change all positive values to negative and reverse the sign of all values with above steps.
1. This function supports Undo.
2. The function does not support formula cells, and all formula cells will be automatically ignored.
Video 1. Change Sign of Values feature demo.