Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mergefield French number
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbering and Automatic Change of Reference Number | Microsoft Word Help | |||
How do I insert chapter number with page number in footer? | Microsoft Word Help | |||
Page numbering in footers, Outside margin, Page Number + Number of Pages | Page Layout | |||
How do I get rid of a page number on a Save As\ Text Only doc? | Microsoft Word Help | |||
Math In Merge Field(s) | Mailmerge |