Limit decimal places in mail merge document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diana Corl - 28 Sep 2005 13:28 GMT

No one seems to know how to limit the number of decimals showing in a mail
merged document. Excel has the ability to limit to two decimals, but when
imported into the mail merge it adds several decimals and does not allow
editing of the decimal places.

Reply to this Message

macropod - 28 Sep 2005 13:56 GMT

Hi Diana,

If you select your mergefield and press Shift-F9 to expose the field coding,
you should see something like:
{MERGEFIELD ExcelData}
To limit the number of decimal places, you need to add a numeric picture
switch to the field, thus:
{MERGEFIELD ExcelData \# ,0.00}
The number of 0s after the decimal point controls the level of precision.
The leading comma is a thousands separator.

Cheers

> No one seems to know how to limit the number of decimals showing in a mail
> merged document. Excel has the ability to limit to two decimals, but when
> imported into the mail merge it adds several decimals and does not allow
> editing of the decimal places.

Reply to this Message

Graham Mayor - 28 Sep 2005 14:13 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> No one seems to know how to limit the number of decimals showing in a
> mail merged document. Excel has the ability to limit to two
> decimals, but when imported into the mail merge it adds several
> decimals and does not allow editing of the decimal places.

Reply to this Message

Rate this thread: