First 0 of zip code drops in an Excel spreadsheet merge

Tags:
Microsoft Excel
I use an Excel spreadsheet to mail merge mailing labels. Whenever I merge, the first 0 in any zip code gets drop in the final label. How do I prevent the zip code field from dropping that first 0?


Software/Hardware used:
Word 2010, Excel 2010
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • azohawk

    Make the zip-code column a text column, that may involve entering a single quote (') prior to the leading zero for some of the data. 

    You may create an "alternate" zipcode field in Excel,  =Contatinate(" ' ", D3) to use (I included a space for clarity, and D3 referes to the cell where the zip code is). 

    4,055 pointsBadges:
    report
  • ToddN2000
    You can try custom formatting the column with 00000 to keep the leading zero. Or make it a text field.
    134,495 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: