I have a column of 50 numbers

  • Thread starter Thread starter Skip
  • Start date Start date
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
 
Assuming they start in A1, put this in B1:

=ABS(A1)

and copy this down.

Hope this helps.

Pete
 
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 -
Click to expand...

Can I make all the numbers negative?
 
Back
Top