Word table exported to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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

how to show numbers that begin with 0 in excel 2
Preformatting Excel Prior to Opening Spreadsheet 1
Starting with a zero? 3
Lead Zeros in Text 6
adding extra digits to columns 2
How do I stop Excel from dropping leading zeros? 9
How can I display numbers beginning with zero? 4
Another Leading Zero Question 7

Back
Top