Importing from Excel to Outlook
 

When I try to import to Outlook from Excel I'm having a problem with
zip/postal codes. All of my zips are in New Jersey and the first number of
the zip is zero (0). I set the excel worksheet to recognize that column as
"special, zip code" but when Outlook tries to pull in the data it's dropping
off all the zeros leaving me with a 4 digit zip, sans the zeros. So
frustrating. Please help!

Thanks!

Importing from Excel to Outlook
 

Perhaps format the Excel field as text?

"Bob" wrote in message
...
When I try to import to Outlook from Excel I'm having a problem with
zip/postal codes. All of my zips are in New Jersey and the first number of
the zip is zero (0). I set the excel worksheet to recognize that column as
"special, zip code" but when Outlook tries to pull in the data it's
dropping
off all the zeros leaving me with a 4 digit zip, sans the zeros. So
frustrating. Please help!

Thanks!

Importing from Excel to Outlook
 

Thanks for the response... I did try that. When I format as text, it drops
the zeros from the worksheet so they are not even present when Outlook trys
to pull the data over. Seems like such a simple thing, right??? I have been
recking my brain and Goolge to no avail.

"DL" wrote:

Perhaps format the Excel field as text?

"Bob" wrote in message
...
When I try to import to Outlook from Excel I'm having a problem with
zip/postal codes. All of my zips are in New Jersey and the first number of
the zip is zero (0). I set the excel worksheet to recognize that column as
"special, zip code" but when Outlook tries to pull in the data it's
dropping
off all the zeros leaving me with a 4 digit zip, sans the zeros. So
frustrating. Please help!

Thanks!

Importing from Excel to Outlook
 

I figured it out... You have to save the excel file as tab delimited. Then,
import that file into outlook.

"Bob" wrote:

Thanks for the response... I did try that. When I format as text, it drops
the zeros from the worksheet so they are not even present when Outlook trys
to pull the data over. Seems like such a simple thing, right??? I have been
recking my brain and Goolge to no avail.

"DL" wrote:

Perhaps format the Excel field as text?

"Bob" wrote in message
...
When I try to import to Outlook from Excel I'm having a problem with
zip/postal codes. All of my zips are in New Jersey and the first number of
the zip is zero (0). I set the excel worksheet to recognize that column as
"special, zip code" but when Outlook tries to pull in the data it's
dropping
off all the zeros leaving me with a 4 digit zip, sans the zeros. So
frustrating. Please help!

Thanks!

Importing from Excel to Outlook
 

If a cell is formated in text it will display '0123' when this is entered

"Bob" wrote in message
...
Thanks for the response... I did try that. When I format as text, it drops
the zeros from the worksheet so they are not even present when Outlook
trys
to pull the data over. Seems like such a simple thing, right??? I have
been
recking my brain and Goolge to no avail.

"DL" wrote:

Perhaps format the Excel field as text?

"Bob" wrote in message
...
When I try to import to Outlook from Excel I'm having a problem with
zip/postal codes. All of my zips are in New Jersey and the first
number of
the zip is zero (0). I set the excel worksheet to recognize that
column as
"special, zip code" but when Outlook tries to pull in the data it's
dropping
off all the zeros leaving me with a 4 digit zip, sans the zeros. So
frustrating. Please help!

Thanks!