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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joel Jacklich - 09 Oct 2006 00:06 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 09 Oct 2006 04:36 GMT

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

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

> When getting mailing labels from data from an Excel (.xls) file, the zip
> code
[quoted text clipped - 3 lines]
> whether I save that data as "text". The ".0" (without the quotes) appears
> after the merge. How do I get aroung this?

Reply to this Message