Zip code formatting problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lori - 21 Apr 2004 01:41 GMT

When I merge an Excel database into a Word document for labels, my zip code field is 5 digits followed by a decimal point and a zero. I have the field formatted to text. What am I doing wrong?

Reply to this Message

Charles Kenyon - 21 Apr 2004 02:03 GMT

With Word/Excell 2003 I just tried a merge with a zip field.

I formatted the first record as a number with 0 decimal places, the second
as text, and the third as general.

The zip code came through fine with each of these and I wasn't able to
replicate your problem.

Signature

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> When I merge an Excel database into a Word document for labels, my zip code field is 5 digits followed by a decimal point and a zero. I have the

field formatted to text. What am I doing wrong?

Reply to this Message

Doug Robbins - Word MVP - 21 Apr 2004 05:55 GMT

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

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

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> When I merge an Excel database into a Word document for labels, my zip code field is 5 digits followed by a decimal point and a zero. I have the

field formatted to text. What am I doing wrong?

Reply to this Message

Rate this thread: