Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
".0" added to zip code in Word 2003
I'm using Word 2003, and for some reason, when mail merging with an
Excel database file, Word will add ".0" to the zip code, resulting in something like this: Mr. Melvin M Person 1710 Alder Creek Ct San Jose, CA 95148.0 (note the extraneous 0) I'm out of my mind trying to figure this problem out. This hasn't happened until recently. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
".0" added to zip code in Word 2003
Fix it with a numeric switch on the merge field \# "00000"
See the zip section of http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org wrote: I'm using Word 2003, and for some reason, when mail merging with an Excel database file, Word will add ".0" to the zip code, resulting in something like this: Mr. Melvin M Person 1710 Alder Creek Ct San Jose, CA 95148.0 (note the extraneous 0) I'm out of my mind trying to figure this problem out. This hasn't happened until recently. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
".0" added to zip code in Word 2003
After toggling the field codes, I get this for the address block:
{ ADDRESSBLOCK \f "_TITLE0__FIRST0__LAST0__SUFFIX0 _ _STREET1__STREET2__CITY__STATE__ POSTAL_ _COUNTRY_" \l 1033 \c 2 \e "United States" \d } I've looked at the link you gave, but it deals with "MERGEFIELD", and after trying the numeric switch, the zip code wouldn't appear at all. On Jul 7, 10:57 pm, "Graham Mayor" wrote: Fix it with a numeric switch on the merge field \# "00000" See the zip section ofhttp://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org wrote: I'm using Word 2003, and for some reason, when mail merging with an Excel database file, Word will add ".0" to the zip code, resulting in something like this: Mr. Melvin M Person 1710 Alder Creek Ct San Jose, CA 95148.0 (note the extraneous 0) I'm out of my mind trying to figure this problem out. This hasn't happened until recently.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What does "char" "char1" "char2" mean in styles in Word? | Microsoft Word Help | |||
Word 2003 corrects "So did I". to "So did me." | New Users | |||
Is there a "Code Snippet" like feature in Word 2007? | Microsoft Word Help | |||
How can I open an "openoffice" ".odt" file in Word 2003 | New Users | |||
Word missing from "Open With" Dialog and cannot be added | Microsoft Word Help |