Forum Discussion
Formatting merge fields to european format
I have some numbers, coming from an excel file, which I want to show in a Word document. I want the numbers to be formatted in a european way, with a comma seperating the decimals and the integers. ...
Hi gerarddn
This is a Word forum, your question is related to Excel. However, you have two options how to fix that.
1. In Excel: click File → Options, under Advanced find 'Editing options', type your separators in the Decimal separator and Thousands separator boxes. However, for a permanent solution, you must change the regional settings in Control Panel.
2. In Word (based on an assumption that you do have decimal and thousand separators present): transfer as is into Word. Open 'Find and Replace', and replace. You need to be clever about it. Replace the first one (a comma, for example) with an 'x', then replace fullstop with a comma, then replace 'x' with a fullstop.