Quickly Change Sign of Numbers in Excel 2007/2010

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.

Click "Kutools">>"Modify">>"Change Sign of Values". See screenshots (Fig. 1 and Fig. 2).


Fig. 1 Change Sign of Values		Fig. 2 Change Sign of Values dialog box

Usage:

Select the cells or ranges you want to change sign;
Choose an option from the Operation;
Click OK.

Note: The function does not support formula cells, and all formula cells will be automatically ignored.

See Change Sign of Values feature demo (video 1)

Video 1. Change Sign of Values feature demo.