column of negative numbers into positive numbers

[Guest]

Hello all-

If I have a column of negative numbers and I want them all to become
positive numbers (-500 becomes 500, etc.), is there a quick way to do this?
Also, if the column has a positive number in it, I would that to become
negative...
Thanks - Jason

 

[David Biddulph]

Put -1 in a spare cell, select and copy, select your column, edit/ paste
special/ multiply. Delete your -1 now you've finished with it.

 

[Guest]

=-A1