Excel convert signs
It would be really efficient to have a functionality in Excel to be able to convert the numbers sign (Positive to Negative, Absolute) and also to convert data formatted as 15.15- to -15.15 (That is the sign is on the right where it should be on the left)
This is already supported. To convert signs,
1. Type -1 in a cell
2. Copy the cell that contains -1
3. Select the range you want to convert
3. On the Ribbon, choose Paste Special (or press Ctrl+Alt+V)
4. Choose Multiply
That will convert all numbers in the selected range to the opposite sign.
1 commentComments are closed
Kenneth Barber commented
When would you use this and what advantage does this have over using a calculated column? The calculated column has the advantage of leaving your original data alone. This lets you more easily track the "edits" that you make to put your data into a more usable format.