跳到主要內容

如何在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  /  將頁面匯出為圖像  /  一次列印多個文件...

內容編輯: 批量查找和替換 跨多個文件  /  調整所有圖片的大小  /  轉置表行和列  /  將表格轉換為文字...

🧹 輕鬆清潔: 移開 多餘的空間  /  分節符  /  所有標題  /  文本框  /  超鏈接  / 如需更多拆卸工具,請前往我們的 刪除組...

創意插入: 插入 千位分隔符  /  複選框  /  單選按鈕  /  QR Code  /  條碼  /  對角線表  /  公式標題  /  圖片說明  /  表格標題  /  多張圖片  / 發現更多 插入組...

🔍 精準選擇:精確定位 特定頁面  /    /  形狀  /  標題段落  / 增強導航功能 更多 選擇功能...

星級增強: 快速導航至任何位置  /  自動插入重複文字  /  在文檔視窗之間無縫切換  /  11 轉換工具...

???? 想嘗試這些功能嗎? Kutools for Word 提供了 60天免費試用,沒有任何限制! 🚀
 
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