Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging labels with zipcode with additional four digits | Mailmerge | |||
Save As creates a copy of file and appends (2) | Microsoft Word Help | |||
TAB key appends new row to table - can this be turned off | Tables | |||
zipcode problem with mailmerge using excel. | Mailmerge | |||
how do i put a list of businesses in zipcode order | New Users |