Not printing 0 in zipcodes from excel spreadsheet.

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
2 Files with Different Fields 6
how do I enter a zipcode starting with a 0 2
Zip codes that start with zero 1
Mail Merge Labels (Word 2007) w/ Excel (2007) 2

Back
Top