Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I input zeroes in a zip code for a mail merge?
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? |
#2
|
|||
|
|||
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 Quote:
__________________
--- SirKnightly |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I input zeroes in a zip code for a mail merge?
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. "S_Suarez" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
Change case...help please | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |