| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Zip Codes Correctly for a Mailmerge
In Version 2003, for a mailmerge using data in Excel, how does one format the
cells for the Zip Codes so that the Zip Code numbers starting with 0 will appear in the word merge. For example, the Zip Code for Englewood, NJ is 07631, and if the Zip Code cells are formatted as Number, Special, General, or even programmed in Custom, the first digit "0" does not appear in the merge, but the only the "7631" appears. On the other hand, if the Zip Code cells are formatted as Text, only the first digit "0" appears in the merge, but not the remaining digits of the Zip Code. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting cell format based on format codes | Excel Programming | |||
| Mailmerge zip codes | Excel Discussion (Misc queries) | |||
| How can I get excel to mail merge zip codes plus 4 correctly? | Excel Worksheet Functions | |||
| Date format for mailmerge | Excel Discussion (Misc queries) | |||
| how to format zip codes | Excel Discussion (Misc queries) | |||
Threaded Mode
