Format imported zip code to appear in Contacts w/o decimals?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excel to Outlook User - 18 May 2005 19:50 GMT

When importing Excel data into Outlook Contacts, the 'home address postal
code' zip code appears with a decimal followed by 3 digits - even though the
column only offers "text" format (right click). Formatting in Excel as
'general', 'number', 'zip' or 'zip+4' makes no difference. The only thing
I've found that works is manually entering an apostrophe at the beginning of
each zip code in the Excel worksheet. Does anyone know an easier way to
automatically fix this so when I import the data from Excel to Outlook
Contacts that the zip appears exactly the way I entered it in Excel?

Reply to this Message

Karl Timmermans - 18 May 2005 20:19 GMT

Your Excel ZIP column is being interpreted as a numeric field when imported
into Outlook - you should also be having the same problem with your phone
number fields and if not - then duplicate whatever you've done for phone
numbers.

Quick solution is to save the worksheet as a CSV file and import that which
generally solves the problem.

Karl

Signature

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

> When importing Excel data into Outlook Contacts, the 'home address postal
> code' zip code appears with a decimal followed by 3 digits - even though
[quoted text clipped - 6 lines]
> automatically fix this so when I import the data from Excel to Outlook
> Contacts that the zip appears exactly the way I entered it in Excel?

Reply to this Message