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.
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.