Thank you! I just tried again, for the umpteenth time, saved as a CSV file,
then saved again in Notepad. This time I imported zip codes complete with
leading zeroes! I didn't understand your reference to method 083938999938,
but when I saw the correct zip codes in Notepad, I began to think this might
actually work!
Thank you, again.

" wrote:

On Oct 1, 10:22 am, "Karl Timmermans" wrote:
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!- Hide quoted text -

- Show quoted text -

when you save the xls file using method '083938938 and then save it as
csv file never open it using excel again.
just import the file and you ll find zero. if you want to at al open
it use a notepad. it is excel that removes o if you open csv formated
file.