Mailmerge

From MC Chem Wiki
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.