- 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"
Sunday, March 3, 2013
Excel: Changing a column of negative numbers to positive
Great and simple tip that I found on the MrExcel.com website:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment