Although you have done this
The cells have been formated as number - special - zip code.
My guess is that some of the ZIPs are still actually "numbers formatted
as text" rather than "genuine numbers." If the first 8 rows in the
column are genuine numbers, then when Word gets the data, it will set
any text values to 0 (even if they look like numbers).
You /may/ be able to see which are texts by making the column wider than
about 5 characters, and looking down the column. If the ZIP is
left-justified, it suggests that it a number formatted as text. If it is
right-justified, it suggests that it is actually a number looking at the
column. If there are just a few numbers formatted as text, you can
consider re-applying the formatting (as necessary) /then re-entering the
number/ - after that, it should be a "genuine number" However, I
wouldn't want to rely completely on this approach.
Another possibility is to format the column as "General" via Data|Text
to Columns...
- select the column
- select the Data|Text to Columns... menu option (in Word 2007, Data
tab-Data Tools group-Text to columns)
- click Next through the wizard until you reach Step 3 of 3, then
select General as the Column Data Format.
- complete the wizard.
If necessary, re-apply the formatting you want to the column.
If your ZIPs are "genuine numbers", in Word you will need to modify the
mergefield to format thtem correctly, e.g., use Alt-F9 to view the field
codes, look for the zip field (let's say it is "myzip") and change
{ MERGEFIELD myzip }
to
{ MERGEFIELD myzip \#00000 }
There is an explanation of some of this stuff at
http://tips.pjmsn.me.uk/t0003.htm
Peter Jamieson
http://tips.pjmsn.me.uk
Penelope wrote:
When the mail merge is completed for either envelopes, labels or letters some
of the zip codes are converted to a 0 instead of the complete 5 digit code.
The cells have been formated as number - special - zip code.