If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
zip code starting with 0 to show in merged letter
when I merge zip codes starting with 0 into letters the 0 doesn't show
up...how can I get it to show? |
#2
|
|||
|
|||
zip code starting with 0 to show in merged letter
Hi Debbie,
To control the zip-code number formatting for a 5-digit zip-code in Word, add a numeric picture switch to the mergefield. To do this: .. select the field; .. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD ZipCode}; .. edit the field so that you get {MERGEFIELD ZipCode \# 00000} .. press F9 to update the field .. run your mailmerge. If you're using 5+4-digit Zip Codes, the following field code correctly formats both 5-digit and 5+4-digit Zip Code data, even where the source data may have incorrect formatting such as a hyphen followed by trailing 0s after plain 5-digit Zip Codes (eg because a db only accepts Zip Codes in the 5+4-digit format) or is formatted as a 5-digit or 9-digit string without hyphens. A data field named ‘ZipCode’ is assumed. {QUOTE {SET Zip {MERGEFIELD ZipCode}} {IF{Zip} 99999 {SET Zip {Zip \# "00000'-'0000"}}} "{=-{=-{Zip}-Zip}/2 \# 00000;;}{=-({Zip}*(-1)-Zip)/2 \# ;-0000;}"} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [Microsoft MVP - Word] "Debbie" wrote in message ... when I merge zip codes starting with 0 into letters the 0 doesn't show up...how can I get it to show? |
Thread Tools | |
Display Modes | |
|
|