Copied data auto-formatted in Excel

H

Hammer

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).

Thanks.
 
D

David Biddulph

Hammer said:
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).
Click to expand...

Paste Special/ Values?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Preserving '00nnnn' in xls to csv file saving 1
Can General format numbers be mistaken as text? 6
Zip Code formatting problem 3
Excel 2003 - Importing External Data - formatting problem? 2
formatting when pasting into excel 1
CONVERTING MS WORD FORMATTED DATA INTO EXCEL WORKSHEET 3

Top