Conversion of numbers to absolute

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:21 PM GMT


QUESTION: I have a column of 1000 numbers some positive some negative. How can I convert all the numbers to their absolute value. I have very limited knowledge of excel. Thankyou Jerry

ANSWER: Assuming your number is in A1, then in A2 for example, use the formula below and copy and paste as far down as needed


---------- FOLLOW-UP ----------

QUESTION: I have a list of 500 negative I tried what you said and it would appear that I have to enter the individual number in the equation you supplied if that's the case I might as well just enter the positive value manually in the next column. Am I misinterpreting what you said? I entered =ABS(A1) and got an error


I don't know how you are interpretting what I had suggested so I can't answer that. Try this:

Type -1000 in C1 and make sure C1 is formatted as a number and NOT text. In D1, type =ABS(C1) and you should get 1000. If that works, and it should, then my suggestion works.

Then you should be able to do what I have suggested.


©2021 eLuminary LLC. All rights reserved.