How do I format a cell to convert negitive numbers to positive?

[Guest]

i have a cell that is is equil to another cell that will always be a negitive
number. I need to convert that number and have it display as a positive
number. How can i do that?

 

[John P]

if a1 is -10 then a2 will be =-a1.

Cheers


John

 

[Ron Rosenfeld]

i have a cell that is is equil to another cell that will always be a negitive
number. I need to convert that number and have it display as a positive
number. How can i do that?

Formatting only controls how cell contents are displayed. Formatting does not
"convert" numbers.

You need to use a function to convert a number.

Depending on what you are trying to do, =ABS(A1) in some cell will always
convert the value in A1 to a positive number.


--ron

 

[John P]

Aha!

Good point Ron,
Cheers

John

Formatting only controls how cell contents are displayed. Formatting does
not
"convert" numbers.

You need to use a function to convert a number.

Depending on what you are trying to do, =ABS(A1) in some cell will always
convert the value in A1 to a positive number.


--ron