I have a column of #s whose values are linked to a different worksheet. Some
#s are positive, others have a negative sign. I tried to search for the
negative symbol using the search/replace method you describe, but my search
both by "formulas" and by "values" does not find anything--yet I can see
several cells have negative numbers in them. Any thoughts?

"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