ZIP with decimal added

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SToon63 - 21 Jul 2005 21:09 GMT

I read a similar post on this after doing a search, but admit the answer
wasn't clear. The problem: when I do a mail merge into Word from an Excel
file, the ZIP field imports with a decimal place and zero afterward (ie:
77449.0).

The previous answer from Graham Mayor was this:

"You cannot alter the inserted field <zip>. You must toggle the field to
{Mergefield Zip} before adding the switch, then F9 to update - see
http://www.gmayor.com/formatting_word_fields.htm"

I don't know what "toggle the field" means or how you get to "{mergefield
Zip}. What is a "switch"? I did go to the suggested webpage and was still
confused. I succeeded in adding the "view field codes" button to my toolbar,
but don't know how to use it. Also, I saw nothing on the webpage regarding
the decimal problem.

Sorry for my ignorance of directions that are probably clear to most, but I
could use your additional help. Thanks.

Reply to this Message

Doug Robbins - 21 Jul 2005 22:06 GMT

Either the Toggle fields item in Tools>Options>View, or Alt+F9

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 read a similar post on this after doing a search, but admit the answer
> wasn't clear. The problem: when I do a mail merge into Word from an Excel
[quoted text clipped - 17 lines]
> I
> could use your additional help. Thanks.

Reply to this Message

Graham Mayor - 22 Jul 2005 05:54 GMT

Either use the method suggested by Doug, or right click the field and choose
toggle from the options. This will display something like
{Mergefield Zip}
Where Zip is the name of your field.
Change that to read
{Mergefield Zip \# "00000" }

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I read a similar post on this after doing a search, but admit the
> answer wasn't clear. The problem: when I do a mail merge into Word
[quoted text clipped - 15 lines]
> Sorry for my ignorance of directions that are probably clear to most,
> but I could use your additional help. Thanks.

Reply to this Message

Rate this thread: