No Auto date formate

L

Lucent1698

Hi,

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

David Biddulph

Lucent1698 said:
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?
Click to expand...

Format the cells as text, then Paste Special/ Text
 
Top