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

For example:
a1 = -$5000

then a2 = $5000


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=557103