| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Word table exported to Excel
In the Word table a column with ISBN numbers begins with zeros. These zeros
are dropped with importing the table to Excel. How can I import these numbers that begin with zero so the beginning zeros will show in Excel? |
|
#2
|
|||
|
|||
|
Try pre-formatting the Excel target range as Text.
If that won't help, save the Word file as a *.TXT file and import from there. Gord Dibben Excel MVP On Thu, 24 Mar 2005 12:09:03 -0800, "rwSRA" wrote: In the Word table a column with ISBN numbers begins with zeros. These zeros are dropped with importing the table to Excel. How can I import these numbers that begin with zero so the beginning zeros will show in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Word tables to Excel | Excel Discussion (Misc queries) | |||
| Copy & paste from Word to Excel with hyperlinks | Excel Discussion (Misc queries) | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
| Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) | |||
Linear Mode
