my public notepad
Monday, January 20, 2014
Excel tip: Change a column of negative numbers to positive
-Go to a blank cell and enter -1.
-Select that cell and perform a "copy".
-Select the entire range of Negative Numbers you'd like to convert.
-Perform an Paste Special, Multiply.
for this one
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)