I have a column of 50 numbers

S

Skip

I have a column of 50 numbers. About half are negative. Is there a
formula I can use to change
all the numbers to positive numbers? Thanks Skip
 
P

Pete_UK

Assuming they start in A1, put this in B1:

=ABS(A1)

and copy this down.

Hope this helps.

Pete
 
J

John

Hi skip
Maybe not the nicest way to do it but should work.
=IF(A1>0,A1-A1*2,A1)
Change cell reference to your need and copy down.
HTH
John
Hi Skip
You can use =ABS(A1) and copy down
HTH





- Show quoted text -

Can I make all the numbers negative?
 

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

Top