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.

thanks to for this one

No comments:

Post a Comment