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" <rwSRA@discussions.microsoft.com>
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?