Word 2003 Mail merge of numbers outputs 15 digit decimal number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank J. Vigil - 02 Mar 2004 03:41 GMT

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.

Reply to this Message

macropod - 02 Mar 2004 06:04 GMT

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.

Reply to this Message

Graham Mayor - 02 Mar 2004 06:21 GMT

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.

Signature

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

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

> 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.

Reply to this Message

Rate this thread: