Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Joel Jacklich Joel Jacklich is offline
external usenet poster
 
Posts: 1
Default MSWordToolsMergeLabels from XLS appends .0 to Zipcode. FIX?

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default MSWordToolsMergeLabels from XLS appends .0 to Zipcode. FIX?

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

"Joel Jacklich" Joel wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
merging labels with zipcode with additional four digits Mission Possible or Impossible Mailmerge 1 July 27th 06 12:20 AM
Save As creates a copy of file and appends (2) Mark Higashigawa Microsoft Word Help 0 March 16th 06 12:36 AM
TAB key appends new row to table - can this be turned off Steven Marzuola (remove wax and invalid for reply) Tables 1 June 8th 05 11:32 PM
zipcode problem with mailmerge using excel. pamsf Mailmerge 1 May 10th 05 04:46 PM
how do i put a list of businesses in zipcode order arlenesab42 New Users 2 February 20th 05 08:15 PM


All times are GMT +1. The time now is 08:09 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"