My mail merge is rounding my originating values. WHY?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janice - 12 Sep 2006 22:44 GMT

I have a dollar value in a column I am trying to merge onto a Word document.
Once merged, the word doc rounds out the dollar value.
Ex: $100.12 turns into $100.120000000001
Only some pages of the merge are doing this, and I've tried changing the
Excel column's format, but it doesn't seem to help.
Does anyone know how to fix this?

Reply to this Message

Doug Robbins - Word MVP - 13 Sep 2006 04:30 GMT

I would not call that "rounding", but see

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a dollar value in a column I am trying to merge onto a Word
>document.
[quoted text clipped - 3 lines]
> Excel column's format, but it doesn't seem to help.
> Does anyone know how to fix this?

Reply to this Message

Janice - 13 Sep 2006 20:45 GMT

I know it's not rounding, but didn't know what the opposite of that would
be...expanding? Your link was easy to follow and very helpful. My problem is
solved! Thanks!

> I would not call that "rounding", but see
>
[quoted text clipped - 7 lines]
> > Excel column's format, but it doesn't seem to help.
> > Does anyone know how to fix this?

Reply to this Message