How do I format a zip code in a mail merge

S

SV1964

When using mail merge, how do I format a ZIP Code that starts with 0 (zero)
from an Excel File, so that when it comes into MS Word, it will not display a
0, but the entire ZIP Code (i.e. 02487). When it is merged, it is displayed
as 0, not 02487. I tried changing the format to TEXT, instead of number, but
it does not work. In other words, it doesn't like the leading 0.
 
K

Karl H

This doesn't seem to work for a Publisher merge document. Is there a
different technique for those files? Opening a publisher file in Word doesn't
show text that is readable.
Karl
 
C

Chuck Davis

Karl,

In the cell that contains the offending zip code preceed the 02487 with the
single apostrophy, as: '02487 The apostrophy will not print.
 
K

Karl H

Thanks for responding, Chuck.
My problem is a little different...& maybe I responded in the wrong thread,
but I am not having a problem with the leading zero not printing, but rather
gettting MS Publisher to pick up the format from Zip + 4 and bring it into
Publisher retaining that format. It eliminates the hyphen.

Karl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

zip codes on postcards 2
Mail Merge - displaying a conditional number of decimals 5
Zip code formating problem 3
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Zip codes not showing up correctly in mail merge 4
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Date Formats 4
Converting URLs in comments to Markdown-formatted links 2

Top