| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copied data auto-formatted in Excel
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How to get Excel to auto sum after it has been saved with data. | Excel Discussion (Misc queries) | |||
| Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
| converting copied data to numbers in excel xp | New Users to Excel | |||
Linear Mode
