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

Perhaps something like a single apostrophe at the beginning will work.

NUMBA = "'" & NUMBA

Stev

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

Steve, great job. Thanks a lot, works like a charm.

Thanks to you as well Jim.


--
Zeroman
------------------------------------------------------------------------
Zeroman's Profile: http://www.excelforum.com/member.php...o&userid=16628
View this thread: http://www.excelforum.com/showthread...hreadid=319505