View original (French)

Decimal number format in mail merge

aromat62 Posted messages 10 Status Membre -  
C-Claire Posted messages 4562 Registration date   Status Membre Last intervention   -
I created a "invoice" template in Word and then performed a mail merge from an Excel file. I have decimal numbers in my database, but when the merge occurs, the field where the decimal numbers should appear in my Word document is rounded to whole numbers. This distorts the amount to be paid on the invoice. Do you have a solution, please?
Thank you very much in advance for providing a solution

--
Posted from CCM Live forum for iPhone/iPad

3 réponses

Réponse 1 / 3
argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   4 842
 
Hello

You need to force the format on the Word file
- Press Alt + F9 to display the field codes
- On the field or fields that display the numbers, you will add \# "# ###,00
So that in the end you have {MERFEFIELD TheNameOfYourField \# "# ###,00}

Press Alt + F9 again to hide the field code

--
Argitxu
3