Mail merge using french currency

Hi Karm,

Word with English regional settings treats the comma as a grouping/thousands separator so the option to use mail merge field code is not recommended.

Therefore, for your concern, the most dependable and consistent approach is to create a helper column in the Excel data table to convert the currency into French formatting:

• Next to the currency data column (e.g. Amount), create a helper column and use this formula =SUBSTITUTE(TEXT(C2,"# ##0.00€"),".",",") to convert the number into French currency

• Then in your Word mail merge, use the Convert helper column instead of the original Amount column so Word will show the data in French currency.

Hope this information would be helpful for your concern. If you have any questions or need further assistance, please don't hesitate to reach out again in the comments on this post so I can continue to support you.

Thank you for your understanding and cooperation. I'm looking forward to your reply.

If the answer is helpful, please click "yes" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.