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

D

Duke55

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

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

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
 
J

John P

Aha!

Good point Ron,
Cheers

John
Ron Rosenfeld said:
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
Click to expand...
 
Top