Thanks, the apostroy thing worked, the formating as text did not.
Thanks for your help.:)


Joe


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=572883