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

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

Guest

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?
 
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
--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Back
Top