Difference between revisions of "Mailmerge"
Jump to navigation
Jump to search
(Created page with "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 t...") |
|||
| Line 4: | Line 4: | ||
:{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}. 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.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. | ||
Latest revision as of 22:01, 28 September 2017
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.