Why is my merge bringing zeros for my ZIPs from Excel to Word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicole - 21 Feb 2008 19:01 GMT

I'm using a spreadsheet from Excel that I created that has approx. 1,500
names and addresses. When merged into my word document, about 200 addresses
show up with the zip code as 0. I've retyped and formatted my Excel
spreadsheet, but the same thing continues to happen. Any idea?

Reply to this Message

Doug Robbins - Word MVP - 21 Feb 2008 22:27 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'm using a spreadsheet from Excel that I created that has approx. 1,500
> names and addresses. When merged into my word document, about 200
> addresses
> show up with the zip code as 0. I've retyped and formatted my Excel
> spreadsheet, but the same thing continues to happen. Any idea?

Reply to this Message