Hi daymaker,
The anomoly is because zip codes with a '-' in them get treated as formulae. The following field code correctly formats 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 or is formatted as a 5-digit or 9-digit string without hyphens. A data field named 'ZipCode' is assumed. Although I've laid the field code out on three lines for legibility, it can be be put on a single line.
{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. You also need to preserve the spaces where indicated.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|