Word – Mail Merge with rounding to 2 decimal places

Julie -  
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   -
Hello,

Before switching to Office 2010 for mail merge in Word from an Excel sheet, I had no problem rounding figures after the decimal point.

However, since the transition to Office 2010, it doesn't work anymore.
When I use the MERGEFIELD code "Nom_de_votre_champ" \#0.00,

instead of the number appearing with 2 digits after the decimal point, it only shows 0.00.

Thank you for your help.
Best regards.

3 réponses

Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
Try with MERGEFIELD "Your_field_name" # "#0.00"

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
0