Home |
Search |
Today's Posts |
#1
|
|||
|
|||
label merge leaves beginning zero off zip code
I have set up the zip code column as a zip code in my excel sheet
but when I attempt to label merge it drops the zero. The zero value check box is checked under Tools/Options. Help |
#2
|
|||
|
|||
Hi, Eva. I assume you're talking about mail merge. Please see:
http://www.officearticles.com/word/m...osoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com "Eva Anne" wrote in message ... I have set up the zip code column as a zip code in my excel sheet but when I attempt to label merge it drops the zero. The zero value check box is checked under Tools/Options. Help |
#3
|
|||
|
|||
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 Eva Anne wrote: I have set up the zip code column as a zip code in my excel sheet but when I attempt to label merge it drops the zero. The zero value check box is checked under Tools/Options. Help -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
You can avoid the problem by making the zipcodes text and not numbers
then you could use zip codes from other countries as well. http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5 If you are going to be specifically printing labels with Mail Merge you might also see my mailmerg.htm page, but I think you've already got that part. -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Eva Anne" wrote in message ... I have set up the zip code column as a zip code in my excel sheet but when I attempt to label merge it drops the zero. The zero value check box is checked under Tools/Options. Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
Change case...help please | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions | |||
mail merge will not accept zip codes that start with a zero "label | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |