How do I fix loosing 1st digit in zip code in mail merge? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Lori 9/24/2006 5:13 PM PST   Question   I have a spreadsheet with headers for a mailing. When I do the mail merge the first digit in the zip code is dropping off. I have the cells formated for zip code and it is still doing the same thing. Working with Office 2003.     Was this post helpful to you?         Reply |   Top           Debra Dalgleish 9/24/2006 5:43 PM PST   Answer   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 Lori wrote: > I have a spreadsheet with headers for a mailing. When I do the mail merge > the first digit in the zip code is dropping off. I have the cells formated > for zip code and it is still doing the same thing. Working with Office 2003. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies