How do I format a merged field in Word to display an amount?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mrs G - 21 Apr 2006 19:13 GMT

I have the main document set up to display an amount, but when I merge the
excel spreadsheet, the amount displays $ 36.350000000000001. I have only
enter 36.35 in the cell on the excel spreadsheet. Can someone tell me how to
fix this to read
$ 36.35?

Also, when I manually delete the extra digits, they still print on my letter.

Reply to this Message

SVC - 21 Apr 2006 20:53 GMT

See this link: http://www.gmayor.com/formatting_word_fields.htm

> I have the main document set up to display an amount, but when I merge the
> excel spreadsheet, the amount displays $ 36.350000000000001. I have only
[quoted text clipped - 3 lines]
>
> Also, when I manually delete the extra digits, they still print on my letter.

Reply to this Message