Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 05-10-2018, 05:30 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft