close

Hi there, copying data from one Excel spreadsheet into another using
Excel 2003. Although the 'receiving' spreadsheet has been formatted as
General, the data autoformats as quot;Numberquot;. Is there any way to turn
this off and have the 'receiving' spreadsheet retain its General
properties? (In my case the numbers have leading zeroes that
disappear).

Thanks.quot;Hammerquot; gt; wrote in message oups.com...
gt; Hi there, copying data from one Excel spreadsheet into another using
gt; Excel 2003. Although the 'receiving' spreadsheet has been formatted as
gt; General, the data autoformats as quot;Numberquot;. Is there any way to turn
gt; this off and have the 'receiving' spreadsheet retain its General
gt; properties? (In my case the numbers have leading zeroes that
gt; disappear).

Paste Special/ Values?
--
David Biddulph

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

    software

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