I have tried everything to get an excel spreadsheet that contains customer
addresses to merge with either Word or Publisher and retain the zip code plus
4 on some of the customers. The customers that have a 5 digit zip code come
through correctly, but the ones that have the plus 4 zip code come through
with a 0 in the zip code fields and nothing else. I have messed with the
formatting function within Excel to no avail. I tried creating my own format
to no avail. I have been online searching this topic and tried the
suggestion of putting the format for the entire column as
[<=99999]00000;00000-000. This did not work either. If anyone has a
suggestion on how to get the 2 types of zip codes to merge into one document
correctly, PLEASE let me know. Thank you!