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 MrExcel.com for this one