How do you convert an entire column into absolute value?
 

x.x

please help ;.;

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 ;.;