Have you tried pasting special and changing the type of text that you
are pasting into the cell/ cells?
Also you may want to try eidt, clear all in the area you are working as
the cell may have been formatted in some manner

SS


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=546946