Zip code formatting problem

L

Lori

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?
 
C

Charles Kenyon

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.
--

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.

Lori said:
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?
 
D

Doug Robbins - Word MVP

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

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


--
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
Lori said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top