Mergefield French number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeannie - 14 Sep 2005 14:11 GMT

I have to merge a number from Access 2003 to a Word 2003 letter. The number
has to be formatted the French way (1 234,56 $). My mergefield is formatted
as follows:
MERGEFIELD SoldeFederal \# "0.00"
Since my regional settings are as French (Canada), I get the following result:
8392,49
The problem is that I am missing a space between the thousands and the
hundreds, since the number should read:
8 392,49
Also, I keep loosing my switch, I believe I might be typing it in the wrong
place because it disappears after every merge to new document
Thanks for your help

Reply to this Message

Doug Robbins - 14 Sep 2005 21:53 GMT

Use the following formatting switch:

\# "0 000,00"

If you save the mailmerge main document after adding the switch inside the
field delimiters of the mergefield { }, it should be retained.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have to merge a number from Access 2003 to a Word 2003 letter. The
>number
[quoted text clipped - 12 lines]
> place because it disappears after every merge to new document
> Thanks for your help

Reply to this Message