Thanks, Gary''s Student.

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

Is there a hidden property in those cells

--
stayin
-----------------------------------------------------------------------
staying's Profile: http://www.excelforum.com/member.php...fo&userid=2323
View this thread: http://www.excelforum.com/showthread.php?threadid=55088