2 Ways to Reverse Number Signs
Ever worked with data where numbers should have been positive instead of negative or vice versa? It can be a painful, not to mention boring task if you have to change the signs manually - a pain in the neck if you ask me!
Luckily, I know two ways which you can perform this task in less than 2 MINUTES so you can spend more time working on that board paper, that assignment, practicing for a presentation...
Let's say you had to convert the numbers from positive to negative:
In another column, select the cell that holds the number(s) and multiply it by -1: e.g. B2 (cell reference)*-1
Enter "-1" in an empty cell, copy and paste special values & multiply. This method also works for cells with formulas as Excel will automatically add "*-1" to the formula.
Option 2 is my preferred method if you ask me!
Comments