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's Profile: http://www.excelforum.com/member.php...o&userid=32543
View this thread: http://www.excelforum.com/showthread...hreadid=523303

No Auto date formate
 

"Lucent1698" wrote
in message ...

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