Linda wrote an article on Formatting Cells in Excel, which explains how to set proper formatting to get the results you want: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=146 And, since she's creating holiday labels, you might want to also point this article to her: Make Your Own Holiday Labels http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=126 Dian Chapman Technical Consultant, Instructor, Microsoft MVP & TechTrax Editor Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html Tutorial web site: http://www.mousetrax.com/techpage.html TechTrax Ezine: http://www.mousetrax.com/techtrax/ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Jan Robey Sent: Saturday, January 11, 2003 6:53 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Disappearing 0 One of my seniors printed labels for her Christmas mailing & she had a situation that I do not know how to correct. So who do I come to? The experts of course! She used the label wizard in Word & she keeps her list in Excel. She is having a problem with the 0 as a first number in her zip codes. The column in Excel is set correctly...while she is in Excel the 0 shows & prints. But as soon as she prints her labels using the Word wizard the 0 disappears. Can you tell me what setting I am missing? Thanks, Jan ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************