Convert negative numbers in place with Excel

Posted 9 years ago - updated 9 years ago numbers maths excel

If you only need to convert negative numbers, you can convert them in-place with Paste Special:

• Add -1 to a cell and copy to the clipboard
• Select the negative numbers you want to convert
• Use Paste Special > Values + Multiply