How to change negative to positive

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

Guest

I copy huge lists of numbers from worksheets e-mailed to me into worksheets
I'm working on. Some people key these as negative numbers. For my purpose,
I need them to be positive. I have been just retyping the whole list, but I
figure there has to be a way to do that much easier. But no matter how much
I search, I can't find anything. Can anyone help? I use Microsoft Excel
2000.
 
=ABS(A1), fill down as far as you need.

You can replace the original data by copying the new data and then Paste
Special, Values.

Be sure to make a copy of your workbook before you do this!

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

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

How to change numbers from positive to negative. 2
Subtracting positive amts from negative and positive from positive 3
Change positive to negative number 4
Converting positive numbers to negative numbers 4
Changing negative numbers to positives.. 2
Change positive number to negative number 1
How to Show "+" for positive and "-" for negative 10
How do I prefix a worksheet of numbers with a Minus (-) Sign 4

Back
Top