Word adding ".0" tothe end of all zipcode mergefields

[jayceejay]

I am using Excel as my data source. I have a field entitled "Zip Code" which
is formatted as "Special -- 5 digit zip." Yet every time I attempt to merge
it to Word and print labels, Mail Merge insists on adding ".0" to the end of
each entry. How do I prevent this from hazppening???

 

[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


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

 

[Doug Robbins - Word MVP]

Nothing has changed in that respect from Word/Office 97 or earlier versions.
Excel does NOT STORE the information in the format that you have selected.

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