No Auto date formate

Hi,

When I copy numbers like 03-05 (which is the year range 2003-2005) to excel, it always automatically reformat that number to Mar-05. How can I just have it display as is without formatting to m/y?

"Lucent1698" <Lucent1698.24s8db_1142545801.3616@excelforum-nospam.com> wrote
in message news:Lucent1698.24s8db_1142545801.3616@excelforum-nospam.com...
>
> Hi,
>
> When I copy numbers like 03-05 (which is the year range 2003-2005) to
> excel, it always automatically reformat that number to Mar-05. How can
> I just have it display as is without formatting to m/y?

Format the cells as text, then Paste Special/ Text
--
David Biddulph