#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
The decimal character is determined by Windows regional settings. Your local setting apparently uses the comma. To get this to work with a full stop (period) you will have to change the regional settings; or change the decimal characters in the data source and work with commas.
You could try applying UK or US English language to the document, but without testing my guess is that this won't work.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
decimal, merge, number |
Thread Tools | |
Display Modes | |
|
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 |