Convert negative numbers in place with 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