Word 2003 Mail merge of numbers outputs 15 digit decimal number

[Frank J. Vigil]

When I merge numeric data from MS Excel 2003 to MS Word 2003, the form field data is displayed with 15 digits after the decimal place. Has this bug been identified? Does this bug exist in Office XP? I did not have this problem in Office Pro 2000.

 

[macropod]

Hi Frank,

Are you sure your Excel data has less digits than this? In any event, easily
enough fixed:

1. Select the errant field and press Shift-F9.
2. After your mergefield reference, but before the \* MERGEFORMAT switch
(if it's there), add: \# "00000" (Change the number of 0s to match your zip
code length). Your field should now look something like { MERGEFIELD Data \#
"00000"} or { MERGEFIELD Data \# "00000" \* MERGEFORMAT }.
3. Press F9 to update.

Cheers

\* MERGEFORMAT

When I merge numeric data from MS Excel 2003 to MS Word 2003, the form

field data is displayed with 15 digits after the decimal place. Has this
bug been identified? Does this bug exist in Office XP? I did not have this
problem in Office Pro 2000.

 

[Graham Mayor]

It's not a bug - it is a reflection of the way Word now connects to external
data. See
http://www.gmayor.com/formatting_word_fields.htm and the Excel data section
of the page it links to.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>