Problem importing ZIP codes from Excel 2002 into Outlook 2003 cont

G

Guest

When I import ZIP codes from Excel into Outlook any leading 0 (zeros) are
truncated (e.g. 02026 imports as 2026). I have tried setting the cell format
within Excel to both Text and Zip Code without success. Visually within Excel
the Zip code appears correct, but does not come into Outlook with the leading
0's. Any ideas?
 
K

Karl Timmermans

As an aside, you should always mention the major/minor version numbers of
the products being referred to - just makes it a lot easier for anyone
answering a question instead of having to ask for it should it be relevant
to the question at hand.

Notwithstanding that, a quick solution around this issue is to save your
worksheet as a CSV file and import that file instead. For whatever reason,
the Outlook import wizard is interpretting your Excel column as a number
field which I'll leave to others to respond to.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 

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

Zip Codes Dropping Leading Zero 3
importing from Excel 1
Importing excel data into Outlook contacts 2
Leading zero from Zip Code not print on Label Merge 6
Converting Zip Codes 3
Importing Zip Codes from Excel File 3
Repost:Converting Zip Codes 7
Importing from Excel to Outlook 4

Top