+ Reply to Thread
Results 1 to 2 of 2

Not printing 0 in zipcodes from excel spreadsheet.

  1. #1
    iamdevoe
    Guest

    Not printing 0 in zipcodes from excel spreadsheet.

    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


  2. #2
    Dave Peterson
    Guest

    Re: Not printing 0 in zipcodes from excel spreadsheet.

    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/as...164951033.aspx

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

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

    about half way down the page.

    iamdevoe wrote:
    >
    > 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


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1