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.

arrow blue right bubbleClick "Kutools">>"Modify">>"Change Sign of Values". See screenshots (Fig. 1 and Fig. 2).

change sign of values arrow-big change sign of values window
Fig. 1 Change Sign of Values
  Fig. 2 Change Sign of Values dialog box

arrow blue right bubbleUsage:

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

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


arrow blue right bubbleSee Change Sign of Values feature demo (video 1)

Video 1. Change Sign of Values feature demo.


arrow blue right bubble This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.

Screen shot

btn read more     btn download     btn purchase