I have a column of 50 numbers

[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

 

[Pete_UK]

Assuming they start in A1, put this in B1:

=ABS(A1)

and copy this down.

Hope this helps.

Pete

 

[John]

Hi Skip
You can use =ABS(A1) and copy down
HTH
John

 

[Skip]

Hi Skip
You can use =ABS(A1) and copy down
HTH





- Show quoted text -

Can I make all the numbers negative?

 

[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?

 

[Pete_UK]

Alternatives:

=-ABS(A1)

or:

=MIN(A1,-A1)

Hope this helps.

Pete