How do I get absolute values for a range of cells?

T

Terry

I various spreadsheets with a mixture of positive and negative numbers. I
would like to make them absolute values. I believe a macro would be
necessary.
 
J

JulieD

Hi Terry

i've just tried this on a SMALL data set - so you might like to test it a
bit more thoroughly before believing in it ... but i selected the range i
wanted to convert to positive values and did
edit / replace
find what: -
replace with: <<leave blank>>

clicked Replace All

seemed to work.

Cheers
julieD
 
P

Peo Sjoblom

Not really, you could use a help column and a simple formula

=IF(A1<0,A1*-1,A1)

copy down/across and then copy and paste special as values,
now you could replace the originals with the help column
 
D

Dave O

It's also possible by way of the ABS() function, which returns the
absolute value of whatever is between the brackets (cell reference,
etc). Would it be easier to use a formula than write and maintain a
macro?
 
Top