Limit decimal places in mail merge document

[Diana Corl]

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.

 

[macropod]

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

 

[Graham Mayor]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>