Ask a new question

Word Merge Switches

I have a one page merge document where one side is English and the duplex side is French.  The data file is Excel so I'd like the amounts on the French side to be the French format.  Is there a merge format switch I can use?  i.e.  make $4,123.45 to be 4 123,45$ on the French side?

 

 

Answer
Answer
I've put this together in a bit of a hurry so some details may need fixing, but...

It's not completely straightforward for a number of reasons. In the case where all your numbers are positive up to around 999,999,999,999.99 and you don't mind how many spaces you have in front of the digits, you can use something like this:

{ ={ MERGEFIELD myamount }*100 \#"### ### ### ##0','00'$'" }

All the {} are the special field braces you can insert using ctrl-F9, and you subsitute your merge field name for "myamount".

If you need more digits, you would need something more like this (there are various ways to do it, and you will need to check how many digits it will work for.

{ QUOTE "{ SET n { MERGEFIELD myamount } }{ =INT(n) \#"-### ### ### ### ##0" },{ =ABS((n-INT(n)))*100 \#00 }$" }

If you don't want all those spaces, I suggest you look at the following document for a different approach:


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 14, 2025 Views 412 Applies to: