Converting Negative Number to Postive number
"Pete" wrote:
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
|