Him Jim,

Thanks for replying. Yes I am trying to code this in VBA. I trie
what you said and it still comes out as Mar-4. The easiest way to fi
this is by selecting the cell before I copy to it and convert it unde
"format cells" to custom. But I want to find a way to code it becaus
the worksheet that I am copying the 3/4 to may not even exist

--
Zeroma
-----------------------------------------------------------------------
Zeroman's Profile: http://www.excelforum.com/member.php...fo&userid=1662
View this thread: http://www.excelforum.com/showthread.php?threadid=31950