Mail Merge

MarcinKuran · #1 05-10-2018, 04:24 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Decimal tabs with space as thousands separator	harry	Word	1	12-22-2023 02:59 PM
Changing decimal separator in charts (comma to dot)	N_Aggelopoulos	PowerPoint	5	04-07-2016 04:56 AM
How to change footnote separator direction	maamiradina	Word	5	05-01-2015 09:39 PM
Decimal alignment of numbers that use blank space as a thousands separator	Aston	Word	1	07-24-2012 11:44 PM
Mail Merge, Number to 2 Decimal Places	Vampy99	Mail Merge	7	09-25-2011 05:41 AM