How do I input zeroes in a zip code for a 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              S_Suarez 8/24/2005 11:34 AM PST   Question   I am trying to do a mail merge for a mass mailing I need to do. I am trying to input zeros in the zip codes that start with zero. When I type in the zero, Excel automatically erases it. How can I input a zero without having excel automatically erase it?     Was this post helpful to you?         Reply |   Top           Duke Carey  8/24/2005 11:39 AM PST   Answer   Format the cells as Text first Format->Cells->Number tab, then select Text "S_Suarez" wrote: > I am trying to do a mail merge for a mass mailing I need to do. I am trying > to input zeros in the zip codes that start with zero. When I type in the > zero, Excel automatically erases it. How can I input a zero without having > excel automatically erase it?     Was this post helpful to you?         Reply |   Top           S_Suarez 8/24/2005 11:54 AM PST   Thank you so much for your help! "Duke Carey" wrote: > Format the cells as Text first > > Format->Cells->Number tab, then select Text > > "S_Suarez" wrote: > > > I am trying to do a mail merge for a mass mailing I need to do. I am trying > > to input zeros in the zip codes that start with zero. When I type in the > > zero, Excel automatically erases it. How can I input a zero without having > > excel automatically erase it?     Was this post helpful to you?         Reply |   Top           db 8/24/2005 11:40 AM PST   Answer   Couple ways: 1) Format the cell as Text: Format->Cells->Text 2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as '00345 3) Enter the zip code with the formula ="00345" Number 1 will probably be most usefull to you. -- Regards, db "S_Suarez" wrote: > I am trying to do a mail merge for a mass mailing I need to do. I am trying > to input zeros in the zip codes that start with zero. When I type in the > zero, Excel automatically erases it. How can I input a zero without having > excel automatically erase it?     Was this post helpful to you?         Reply |   Top           S_Suarez 8/24/2005 11:55 AM PST   Thanks so much! Your post was very helpful! "db" wrote: > Couple ways: > > 1) Format the cell as Text: Format->Cells->Text > 2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as > '00345 > 3) Enter the zip code with the formula ="00345" > > Number 1 will probably be most usefull to you. > -- > Regards, > db > > > "S_Suarez" wrote: > > > I am trying to do a mail merge for a mass mailing I need to do. I am trying > > to input zeros in the zip codes that start with zero. When I type in the > > zero, Excel automatically erases it. How can I input a zero without having > > excel automatically erase it?     Was this post helpful to you?         Reply |   Top           sirknightly 8/24/2005 5:40 PM PST   Suarez, Change the format of the cell. Select the cells into which you are inputting your zip codes, Then click Format...Cells...Number. Click on "Custom" in the list and in the "Type:" field, enter 00000. Knightly S_Suarez Wrote: > I am trying to do a mail merge for a mass mailing I need to do. I am > trying > to input zeros in the zip codes that start with zero. When I type in > the > zero, Excel automatically erases it. How can I input a zero without > having > excel automatically erase it? -- sirknightly     Was this post helpful to you?         Reply |   Top           c_thonus 12/9/2005 7:57 AM PST   If you already have your database typed with the zip codes formatted as "Special Zip" and they appear in excel correct but are incorrect in word when you do your mail merge, then save your worksheet as a .txt or "text" file. Then use this as your database when doing your mail merge. The zeros should be there. "S_Suarez" wrote: > I am trying to do a mail merge for a mass mailing I need to do. I am trying > to input zeros in the zip codes that start with zero. When I type in the > zero, Excel automatically erases it. How can I input a zero without having > excel automatically erase it?     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies