View original (French)

Mail merge word-excel - thousand separator format

myosotis21 Posted messages 3 Status Membre -  
m@rina Posted messages 27191 Registration date   Status Modérateur Last intervention   -
Hello,

In a mail merge Word document with an Excel file, I set this formula for my field EXO_2015 so that the number is properly formatted as 123.456,78
Formula: ***{ MERGEFIELD «EXO_2015» \# #.##0,00 \* MERGEFORMAT }*** euros
While the number 123.456,78 is correctly displayed, I get:
      • . 40,00*** euros (space.space40,00) for 40,00 euros and
      • .180,00*** euros (space.180,00) for 180 euros

Can someone help me fix my formula?

Thanks in advance...

1 réponse

Réponse 1 / 1
m@rina Posted messages 27191 Registration date   Status Modérateur Last intervention   11 542
 
Good evening,

In the French digital format, the thousand separator is a space and not a point. The problem probably comes from there.

m@rina

--
Beware of herbal tea: it's a dangerous poison...
0