Alternatives:

=-ABS(A1)

or:

=MIN(A1,-A1)

Hope this helps.

Pete

On Oct 24, 1:11*pm, Skip wrote:
On Oct 24, 7:57*am, "John" wrote:

Hi Skip
You can use =ABS(A1) and copy down
HTH
John"Skip" wrote in message

....

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- Hide quoted text -

- Show quoted text -

Can I make all the numbers negative?