How do you convert an entire column into absolute value?
Say your data in in column A. In an un-used (helper) column enter:
=ABS(A1) and copy down
Then copy the helper column and paste/special as value back into column A
--
Gary's Student
"Lorraine" wrote:
x.x
please help ;.;
|