How do I get the full Zip code to import when it starts with O?

[Guest]

I am working with an Excel file of data from ACT that I want to import into
Outlook Business Contact Manager. Up here in the Northeast, most of our zip
codes start with 0, so when the data gets exported to Excel it only has four
digits. I format the column so the Zip code displays five digits, yet this
formatting is lost when I save the file as a CSV. How do I keep the 0 in the
data???

 

[Guest]

In Excel, are the cells containing the zip codes in Text format, or are they
in Number format?

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***

 

[Guest]

I was able to figure this out after all. Regardless of whether the numbers
were in text or number format, I had the same issue. What I did was add a
column to the right of the column that had the four digit zip codes (they
were in column M) and in the new column (column N) I entered the following
formula:

=TEXT(M1,"00000")

I then filled this all the way down to the last cell (N1021)

Now, all of the four digit zips have an extra 0 in them. 2201 now shows as
02201.

Next, I highlighted all of column N (which used the formulas), copied, then
selected Paste Special and chose "Values". How, instead of seeing the
underlying fomula, the actual 5 digits are displayed.

I imported all of this data into Outlook from this Excel document and it
worked slick as can be.