View Single Post
  #3  
Old October 1st 07, 07:22 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default Importing contacts from Excel

Your Zip Codes are being treated as numeric fields on import which
eliminates leading zeros.

Quick solution that should resolve your problem::

Save your worksheet as a CSV file and import that instead of the Excel
worksheet

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


"Ginnymc5199" wrote in message
...
I successfully imported contacts from Excel, but zip codes were not
formatted
correctly. They were missing "0" when "0" was the first digit. (Zips were
formatted as zip codes in Excel.) What to do?!?!? Thank you!



Ads