Merge Field doesn't display complete number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rjr - 25 Jun 2006 22:15 GMT

I have a database in excel that I'm using to merge letters. I'm having
trouble in getting the nine digit zipcode to display.
In excel it displays as 12345-4567 in the field.

In WORD I've used this merge field { Mergefield "INVOFCZIP" }

It returns a 0 when I have a nine digit zip code in the datacell. When I
have a 5 digit it prints properly. I really need the 9 digit, how can I get
it to go that way. Is there a switch for the 9 digit zip or something.
Thanks in advance
Bob

Reply to this Message

Doug Robbins - Word MVP - 26 Jun 2006 04:51 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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

>I have a database in excel that I'm using to merge letters. I'm having
>trouble in getting the nine digit zipcode to display.
[quoted text clipped - 7 lines]
> Thanks in advance
> Bob

Reply to this Message