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.

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


"Diana Corl" Diana wrote in message
...
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.

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

--

Graham Mayor - Word MVP

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


Diana Corl wrote:
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.