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

On Oct 24, 12:42*pm, Skip wrote:
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

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

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?

Hi skip
Maybe not the nicest way to do it but should work.
=IF(A10,A1-A1*2,A1)
Change cell reference to your need and copy down.
HTH
John
"Skip" wrote in message
...
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?

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?