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?

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?