Mailmerge

From MC Chem Wiki
Revision as of 22:01, 28 September 2017 by Bes (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This page is to document a fix associated with excessive decimal places in a WORD mailmerge document.

While in a WORD mailmerge document, press alt-F9 and you will then see the following tags...

{MERGEFIELD value}. When the value is a calculated number, WORD will present excessive decimal places. To fix this edit the mergefield as follows:
{MERGEFIELD value \#0.00} <-- this will now show only 2 decimal places.
{MERGEFIELD value \#0.0} <-- this will now show only 1 decimal places.
then hit alt-F9 again to hide the mergefield tags.