Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to get zips beginning with 0 to merge Excel to Word label?
I have several zip codes beginning with 0 in an Excel file. They are
properly formatted in the cell as a zip code; however, when I merge to labels in Word, the 0 is stripped. How can this be fixed? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to get zips beginning with 0 to merge Excel to Word label?
In your master label file (without the merged data), hit Alt + F9 to reveal
the codes. In the field that represents the zip code, after the MERGEFIELD information, type \# 00000. You would have something like {MERGEFIELD "ZIP"\# 00000}. This tells Word to format the merge field as a 5-digit number and to include leading zeros. The best solution in the future is to format the zip codes in Excel as text. "Janice" wrote: I have several zip codes beginning with 0 in an Excel file. They are properly formatted in the cell as a zip code; however, when I merge to labels in Word, the 0 is stripped. How can this be fixed? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to get zips beginning with 0 to merge Excel to Word label?
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Janice" wrote in message ... I have several zip codes beginning with 0 in an Excel file. They are properly formatted in the cell as a zip code; however, when I merge to labels in Word, the 0 is stripped. How can this be fixed? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
How do I create & merge specific data base & master documents? | New Users |