MSWord<Tools<Merge<Labels from XLS appends .0 to Zipcode. FIX?

[Joel Jacklich]

When getting mailing labels from data from an Excel (.xls) file, the zip code
adds ".0" (without the quotes) to the end of the zip code data. It does not
matter if I save that data to Excel as "number/zero decimal places" or
whether I save that data as "text". The ".0" (without the quotes) appears
after the merge. How do I get aroung this?

 

[Doug Robbins - Word MVP]

See the following page of fellow MVP Graham Mayor's website:

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