Adjust Decimal Separator – How to Adjust Decimal Separator in Imported Charts

chartsmicrosoft excelmicrosoft wordmicrosoft-excel-2013microsoft-word-2013

I am about to write an English document with the German versions of MS Word and Excel. I use Excel to create a chart which I import into the Word document (by Copy & Paste).

I can tell Excel to use a custom decimal separator (. instead of ,) via File, Options, Advanced. However, these settings are overruled when I paste the chart into Word and the chart again uses , as the decimal separator (for axis labels).

Is there a way I can configure the decimal separator for the imported chart in Word?

Best Answer

There are at least three places to look:

1) System settings (Windows: Control panel, regional settings, Ubuntu: System Settings, Language support -> Regional formats
which should reflect/be reflected by $ locale)

2) Excel / Spreadsheet settings: Excel, File, Options, Advanced (LibreOffice?)

3) Cell/Item/Object local settings: e.g. Right click 'Chart axis' select 'Format axis' and go to the 'Numbers' tab. or press CTRL+1 with a cell selected.

Related Question