Leading zero in zip code won't print

J

J Mac

I just tried to print a Christmas list many of whom live in N.J.
which has many zip codes that start with a zero. They don't
print. This is with Office 2003. That has to be a fix for this.

Any help please??

Thanks
 
D

Dave Peterson

J

J Mac

Dave Peterson said:
Are you using excel as your database and using mailmerge in MSWord?

Debra Dalgleish posted this to a similar question:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
Click to expand...

Thanks Dave,

That took some reading but the simple answer is just to type
an apostrophe before the leading 0 in a zip code.

Thanks again!!!
 
D

Dave Peterson

Changing the value from numeric to text is one way.

If you wanted to do that, you could have used another column of formulas with:

=text(d2,"00000")

And used that column in the mailmerge.

But that article is something you may want to keep for future reference--if you
ever merge any numeric values that should be formatted nicely.
 
J

J Mac

It was a great article. But what worked for me and was very easy was
simply to put an apostrophe in front of the leading 0. The 0 prints but
not the apostrophe ' .
 
D

Dave Peterson

That's not a bad way to do it if you don't have too many zipcodes to fix.

I'd either use the techniques in the article or that helper column (=text()) if
I had lots of cells to fix.
 
Top