Hey Tedd,
One possibility for that is you can do CTRL+H, replace, in find what,
use "-" and then replace with a blank in 'replace with'. This is
possible but it replaces all the negative numbers. Hence, you can use
this if you need to replace all in the worksheet.
Cheers.


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=502141