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

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.

--
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
"Jeannie" wrote in message
...
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