Zip codes that begin with 0

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I am using Excel 2002 and I am trying to do a mail merge for address labels.
In my "zip code" column, I have a few that begin with 0. I have formatted
the column as a "zip code" column, but when I do the merge, the first 0
drops off.

How do I get the first 0 to stay??

Thanks
 
In Word, after you have inserted the Merge fields, press Alt+F9, to view
the field codes.

In the field code for the Zip Code, you can add a switch to format the
number. For example:
{ MERGEFIELD "Zip" \# "00000" }

Press Alt+F9 again to hide the field codes, then view the merged data.
 
Format numbers as "Zip Code" or "text"

Excel stores numbers as numeric data even if you later apply the text format
to cells that contain the numbers.


On the Format menu, click Cells, and then click the Number tab.
or Right-Click/Format/Number/Special/Zip Code
or Right-Click/Format/Number/Text


In the Category list, click Text, and then click OK.


Click each cell, press F2, and then press ENTER to reenter the data.
 
Back
Top