View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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 ;.;