Mail merge prints out incorrect no. of decimal places from Excel .

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UDDWF - 07 Feb 2005 17:33 GMT

When I try to mail merge using information from an Excel spreadsheet, the
monetary field does not print the correct number of decimals in the form
letter, even though the formatting dialog box indicates 2 decimals. When I
include the $ in the form letter, I get the following printed out:
$18.600000000000001. When I don't include the $ in the form letter I get
18.1. I want $18.60. Thank you in advance for any help.

Reply to this Message

Doug Robbins - 07 Feb 2005 23:22 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 respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> When I try to mail merge using information from an Excel spreadsheet, the
> monetary field does not print the correct number of decimals in the form
[quoted text clipped - 3 lines]
> $18.600000000000001. When I don't include the $ in the form letter I get
> 18.1. I want $18.60. Thank you in advance for any help.

Reply to this Message

Rate this thread: