pettabytes
my public notepad
Pages
Home
Photos
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:
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment