Sunday, March 3, 2013

Excel: Changing a column of negative numbers to positive

Great and simple tip that I found on the website:

  • In any blank cell, enter the number "-1" without quotes and hit enter 
  • Right click on the -1 cell and select copy.
  • Select the entire range of negative numbers you would like to convert.
  • Right click and select "Paste Special" select "Multiply"

No comments:

Post a Comment