:Common mail merge application tips How to use mail merge Set the number of decimal places-Writing skills免费ppt模版下载-道格办公

Common mail merge application tips How to use mail merge Set the number of decimal places

  • Picture and text skills

After the mail merge, the number appears with multiple decimal places. We don’t want this effect. What should I do if I only want to keep two decimal places?


分界线.png

▪Step one: Open the document that has been imported into the data source, close "View Merged Data", then the data will change to the domain name, and then press the key combination "Alt+F9" ” is converted into a field code.


录制_2021_04_19_18_28_59_598.gif


▪Step 2: Insert this symbol (\#0.00) at the "deductible amount" in the field code. Pay attention to both the field name and the added field symbol. , you must use double quotation marks in English, and then press "Alt+ F9"Return domain name, At this time, click to view the merged data and find that two decimal places have been successfully retained.


录制_2021_04_19_18_29_32_815.gif


▪If you want to keep three decimal places, add three digits (\#0.000) after the decimal point of this symbol (\#0.00), and so on


录制_2021_04_19_18_30_06_190.gif



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/chang-jian-you-jian-he-bing-ying-yong-ji-qiao-ru-he-yong-you-jian-he-bing-she-zhi-xiao-shu-wei-shu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion