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.