:Mail Merge Tips: How to Set Decimal Places Precisely-Writing skills免费ppt模版下载-道格办公

Mail Merge Tips: How to Set Decimal Places Precisely

Of course, the following is a rewritten version based on the content you provided, retaining the original HTML and image address information: ```html

Graphic skills

After the mail merge, if the number that appears has multiple decimal places and we only need to keep two decimal places, you can do the following steps:

分界线.png

1. Open the document that has been imported into the data source and turn off the "View Merged Data" function, so that the data will be displayed as domain names. Then use the shortcut key "Alt+F9" to convert the domain name into a domain code.

录制_2021_04_19_18_28_59_598.gif

2. In the field code, find the "Deductible Amount" part and insert the format symbol (\#0.00). Note that both the domain name and the added format symbol must be enclosed in English quotation marks.

Then press the "Alt+F9" key again to return to the display state of the domain name. If you click "View Consolidated Data" again at this time, you will find that the amount has successfully retained two decimal places.

录制_2021_04_19_18_29_32_815.gif

3. If you need to keep three decimal places, just add three digits (\#0.000) after the decimal point of the format symbol (\#0.00), and so on.

录制_2021_04_19_18_30_06_190.gif

```Please note that I have simplified and reorganized some of the step-by-step instructions in the original article to make them clearer and easier to read, while retaining all HTML tags and image links.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/you-jian-he-bing-ji-qiao-ru-he-jing-que-she-zhi-xiao-shu-wei-shu.html