close

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: www.excelforum.com/member.php...oamp;userid=32543
View this thread: www.excelforum.com/showthread...hreadid=523303quot;Lucent1698quot; gt; wrote
in message ...
gt;
gt; Hi,
gt;
gt; When I copy numbers like 03-05 (which is the year range 2003-2005) to
gt; excel, it always automatically reformat that number to Mar-05. How can
gt; I just have it display as is without formatting to m/y?

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()