LinkBack URL
About LinkBacks
How do I convert a column of negative numbers to positive numbers or return the absolute value, easily?
How do I convert a column of negative numbers to positive numbers or return the absolute value, easily?
Hi,
Excel has an absolute value function. See it at:
http://www.excelfunctions.net/Excel-Abs-Function.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks - but that doesn't show me / explain how to apply it to a column that is over 500 entries long.
Like this...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks - I was hoping not to have to add another column though. I know, kind of picky on my part.
It might be possible with VBA, but that would not be for me... Are the data containing the negatives the result of another formula? If so, just wrap the formula up in an ABS function:
=ABS(yourformula)
no other formula involved. Your right VBA is toooooo much for this simple problem.
Thanks!
Nearly right... I'm tooooooo simple to understand VBA.
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
If EVERY number is a negative number...
Let's assume the numbers are in the range A1:A10.
In some empty cell enter -1.
Copy that cell
Select the range A1:A10
Right click>Paste Special>Multiply>OK
Delete the -1 from the cell.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tooooooooooo simple!!
THANKS.
Thanks for the reputation added...
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks