|
Posted to microsoft.public.excel.misc
|
|
|
Showing Negative as Postive
Much better...
"Skeep" wrote:
so if -1.25 in A1 then put a formula in B1 that says =abs(a1), this will
return 1.25 for both a negative and a positive number.
--
Skeep
------------------------------------------------------------------------
Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822
View this thread: http://www.excelforum.com/showthread...hreadid=504849
|