I can't duplicate the problem. Please post an example.
--
Gary's Student


"staying" wrote:


Thanks, Gary''s Student.

Your solution works well except for one case. The problem persists when
you copy a cell which was text formatted with an apostrophe and value
paste it into another cell.

Is there a hidden property in those cells?


--
staying
------------------------------------------------------------------------
staying's Profile: http://www.excelforum.com/member.php...o&userid=23230
View this thread: http://www.excelforum.com/showthread...hreadid=550888