How do I input zeroes in a zip code for a mail merge?

S

S_Suarez

I am trying to do a mail merge for a mass mailing I need to do. I am trying
to input zeros in the zip codes that start with zero. When I type in the
zero, Excel automatically erases it. How can I input a zero without having
excel automatically erase it?
 
D

db

Couple ways:

1) Format the cell as Text: Format->Cells->Text
2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
'00345
3) Enter the zip code with the formula ="00345"

Number 1 will probably be most usefull to you.
 
S

S_Suarez

Thanks so much! Your post was very helpful!

db said:
Couple ways:

1) Format the cell as Text: Format->Cells->Text
2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
'00345
3) Enter the zip code with the formula ="00345"

Number 1 will probably be most usefull to you.
Click to expand...
 
S

sirknightly

Suarez,

Change the format of the cell. Select the cells into which you are
inputting your zip codes, Then click Format...Cells...Number. Click on
"Custom" in the list and in the "Type:" field, enter 00000.

Knightly
 
C

c_thonus

If you already have your database typed with the zip codes formatted as
"Special Zip" and they appear in excel correct but are incorrect in word when
you do your mail merge, then save your worksheet as a .txt or "text" file.
Then use this as your database when doing your mail merge. The zeros should
be there.
 
Top