Use a formula in an adjacent cell and copy this down. If your data is
in A1, in B1 enter:

=ABS(A1)

and copy down for as many values as you have in column A. You can then
fix the values in B and copy them over the ones in A.

Hope this helps.

Pete