remove negative from number

[jermsalerms]

how would I write a formula that converts a negative number to
positive number (must be in number format...not text)

For example:
a1 = -$5000

then a2 = $500

 

[Bearacade]

Use Absolute

=ABS(A1)

HT

 

[tim m]

See if this works for you:
=IF(A1<0,A1*-1,A1)

 

[Ron de Bruin]

Try -1 * the cell with the number

=-1*A1

 

[rnrxtreme]

This would also work:

=(A1^2)^(1/2)

 

[jermsalerms]

I went with the first suggestion ABS(A1)...worked great. Im sure th
other work as well.

Thanks agai