Mail merge decimal bug

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefanus - 11 Feb 2004 20:58 GMT

When I mail merge letters (Word 2003) from an Excel 2003
database the numbers in the Excel document (e.g. 25,2)
will be merged in the Word mail merge letter with up to
20 decimals (e.g. 25,235560000000002223) I've tried to
change the Excel Format Cell to Text, but no success - it
still merges with the numerous confusing decimals. How
do I correct it? I don't want more than one decimal in
the merged letters. (Even if I select 'no decimals to be
shown' in Excel, I still have the merged problem in Word)

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 12 Feb 2004 00:21 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> When I mail merge letters (Word 2003) from an Excel 2003
> database the numbers in the Excel document (e.g. 25,2)
[quoted text clipped - 5 lines]
> the merged letters. (Even if I select 'no decimals to be
> shown' in Excel, I still have the merged problem in Word)

Reply to this Message