View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Copied data auto-formatted in Excel

"Hammer" wrote in message
oups.com...
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 "Number". 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).


Paste Special/ Values?
--
David Biddulph