If your data is in A1:A10 and -1 is in B1, then copy B1, select A1:A10 and
click edit/paste special/multiply.


"Nita" wrote:

If I need to quickly change an entire column (800 rows) of negative numbers
to positive numbers, what is the easiest way. I tried the paste special
multiply by -1, but it didn't work, I'm probably doing it wrong.