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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF absolute value of cells in a range are > 0 8
Absolute values in formulas 1
Flipping numeric values 3
Question about conditional formatting of zeros in Excel 0
Coloring cells 8
Cell References absolute? 3
How to auto enable Excel, set cell color based on the numerical va 3
Absolute Values Summed for a Range 1

Back
Top