跳到主要内容

如何在Word中合并邮件期间格式化日期,货币和数字?

邮件合并是创建一组基本相同但每个文档包含唯一元素的文档的有用工具。 但是,当我们合并某些邮件时,我们应该更加注意日期,货币和数字的格式。 本教程将向您展示如何在邮件合并过程中以单词的形式正确格式化日期,货币和数字。

在Word中的邮件合并期间正确格式化日期

在Word中合并邮件期间正确格式化货币和数字

在更改邮件合并中的日期,数字和货币格式之前,我们需要首先应用以下操作。

步骤1:选择要更改的合并字段。 在这种情况下,它是日期字段。

步骤2:按 SHIFT + F9 使字段编码可见。 您选择的字段现在应如下所示:

{MERGEFIELD DATE},{MERGEFIELD CURRENCY}或{«Percent»}


箭头蓝色右气泡 在Word中的邮件合并期间正确格式化日期

请添加以下格式数据: \ @“ dd MMMM yyyy” 到日期的合并文件中。 并且日期的合并字段应如下所示:

{MERGEFIELD DATE \ @“ MMMM d,yyy”}

日期格式如下:

换孔1

请注意:您可以将日期格式更改为任意格式。 其他可能的格式可能是:•dd / MMM / yyyy,•d / MMM / yy,•d MMMM yyyy


轻松将一个Word文档拆分为多个

通常,我们使用复制和粘贴功能将Word文档一一拆分,但是Split Documnet实用程序可以基于页面,标题1,分页符或分节符来拆分Word文档,这将提高工作效率。  单击以获取全功能免费试用 60 天!
广告按页面拆分文档
 
Kutools for Word:拥有数百个方便的Word插件,免费试用,没有任何限制 60 天。

箭头蓝色右气泡 在Word中合并邮件期间正确格式化货币和数字

请添加以下格式数据 \#$,0.00 放入货币的合并文件中,货币的合并字段应如下所示:

{MERGEFIELD CURRENCY \#$,0.00}

换孔2

请注意:字段中的“ \#$,0.00”称为数字图片开关。 其他可能性包括:

(1)。 \#0表示四舍五入的整数

(2)。 \#,0为带千位分隔符的舍入整数

(3)。 \#,0.00表示精确到小数点后两位的数字,带千位分隔符

(4)。 \#$,0为带千位分隔符的整数

(5)。 \#“ $,0.00;($,0.00);'-'”用于货币,括号内带有负数,连字符表示0值

此外,有时数字可能是百分比,您可能需要编辑字段{«Percent»},以便获得{=«Percent»* 100 \#0.00%}。

最佳办公生产力工具

Kutools for Word - 通过 Over 提升您的文字体验 100 显着特点!

🤖 Kutools 人工智能助手:用人工智能改变你的写作 - 生成内容  /  重写文本  /  总结文件  /  查询资料 基于文档,全部在Word中

📘 文档掌握: 分页  /  合并文件  /  以各种格式导出选择(PDF/TXT/DOC/HTML...)  /  批量转换为PDF  /  将页面导出为图像  /  一次打印多个文件...

内容编辑: 批量查找和替换 跨多个文件  /  调整所有图片的大小  /  转置表行和列  /  将表格转换为文字...

🧹 轻松清洁: 移开 多余的空间  /  分节符  /  所有标题  /  文本框  /  超链接  / 如需更多拆卸工具,请前往我们的 删除组...

创意插入: 插 千位分隔符  /  复选框  /  单选按钮  /  扫码支付  /  条码  /  对角线表  /  公式标题  /  图片说明  /  表标题  /  多张图片  / 发现更多 插入组...

🔍 精准选择:精确定位 特定页面  /    /  形状  /  标题段落  / 增强导航功能 更多 选择功能...

星级增强: 快速导航至任何位置  /  自动插入重复文本  /  在文档窗口之间无缝切换  /  11 转换工具...

👉 想尝试这些功能吗? Kutools for Word 提供了 60-day免费试用,没有任何限制! 🚀
 
Comments (67)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
May i know how to set a date field {MERGEFIELD "PrintDate" } but i would like to display that date +14 days later.

earlier : MERGEFIELD PrintDate \@ "dd/MM/yyyy" then may i know how to + 14 days then display at word?
This comment was minimized by the moderator on the site
Pour le champ monétaire je fais la modification {MERGEFIELD nombre \#"# ###,00 €"}, cela fonctionne, mais quand je ferme la lettre cela n'est pas mémorisé pour l'ouverture suivante, je doit corriger à chaque ouverture de la lettre. pourquoi?
Autre souci avec le bloc d'adresse, je dois l'effacer et le réinsérer à chaque fois.
merci pour votre aide.
This comment was minimized by the moderator on the site
I used the formula above to get my fields to add the comma separator, add the dollar sign, and make negative amounts appear in parentheses, and nothing changed with the fields at all.  What could I be doing wrong?
This comment was minimized by the moderator on the site
Hi there
In MS Word, I want to use a numeric mail merge field with this switch # "$,0.##" at the end of a sentence. If I enter a full stop after the mail merge field, then if the merged data doesn't contain cents, there will be a full stop after the decimal place, which means there will be two full stops next to each other. Could you please tell me if there is a way I can specify that I only want a final full stop if the merged figure contains cents? Many thanks for any assistance
This comment was minimized by the moderator on the site
Hi, Sophie, is your data is whole number or decimal number? If all of your data is whole number, you can try this: \# $,0
This comment was minimized by the moderator on the site
HOW CAN WRITE NUMBER LIKE THIS -2.00 OR +3.00 IN MAIL MERGE
This comment was minimized by the moderator on the site
Hi, KIRAN, if you want to show the number as -$2.00 or $+3.00, you can use this field \# "+ $#,##0.00", if you want to show the number as -2.00 or +3.00, use this filed\# "+#,##0.00"
This comment was minimized by the moderator on the site
Attempting to switch a currency field into words from a mail merge field. Any ideas; nothing I'm doing is working.
MERGEFIELD "TOTALAMOUNTDUE \\* DollarText"
This comment was minimized by the moderator on the site
THANKS GUYS, U RE THE BEST!
This comment was minimized by the moderator on the site
how do i do 23rd of october 2019
This comment was minimized by the moderator on the site
hi..

my date changed to code like this; 43696
anybody can help?
This comment was minimized by the moderator on the site
Hi, I have the same problem ... In other places it is working, but it is one place where I also get the number 4043. Is it something wrong in excel or in word??? The field code looks like {MERGEFIELD Licencijos_data\@ "yyyy-MM-dd"
This comment was minimized by the moderator on the site
I also facing the same problem... i already tried all the format \@ ..... but still not working.

Im using word 2013

Help me plz
This comment was minimized by the moderator on the site
YOU ARE AMAZING.... after years of fighting with currency in mail merges, finally the easiest and RIGHT answer.
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations