Not printing 0 in zipcodes from excel spreadsheet.

G

Guest

When I merge into labels in word it is not printing the 0 of the zipcodes
that start with a 0. I have tried putting a ' in front of it.

Thanks, Christy
 
D

Dave Peterson

Did you put the apostrophe in the data in excel?

'01234

I've don't think I've seen that fail with mailmerge.

But....

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

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://home.earthlink.net/~wordfaqs/CustomizingWord2002.htm

about half way down the page.
 

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

trying to insert a 0 in front of zipcode 2
Create Database Type Lookup In Excel 4
How do I add an apostrophe in front of existing column in Excel? 2
Mail Merge with Excel and Word 1
Zip codes that start with zero 1
how do I enter a zipcode starting with a 0 2
Mail Merge Labels (Word 2007) w/ Excel (2007) 2
Adding a 0 to a four digit number 5

Top