View Single Post
 
Old 05-10-2018, 04:24 AM
MarcinKuran MarcinKuran is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2018
Posts: 1
MarcinKuran is on a distinguished road
Default Mail Merge change of decimal separator

Hello,
I am trying to calculate a sum of two amounts in merge fields that have points as a decimal separator. It does not work as my Word expects commas. How to change a point into a comma in the merge field?

1) Example with point decimal separator:
{ = { MERGEFIELD sum1 } + {MERGEFIELD sum2 } }
{ = 135515.26 + 20409.38 }
Alt+F9 = > !Syntax Error,

2) Example with comma decimal separator:
{ = 135515,26 + 20409,38 }
ALT+F9 => 155924,64 (correct amount)

Best regards,
Marcin
Reply With Quote