Additional Item: The column that includes negative signs is formatted as a
Custom column with 13 zeros...I need to have leading zeroes and 13 places
total. In this format, the Find features does not seem to find the negative
signs.

Thanks again.

"praveen_khm" wrote:


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