my public notepad
Sunday, March 3, 2013
Excel: Changing a column of negative numbers to positive
Great and simple tip that I found on the
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"
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)