Forum Discussion
MS OFFICE 2019 / Dezimaltrennzeichen / Mac Betriebssystem Mojave
Kindly follow the steps to fix this,
1. Type in control panel on your system
2. Under Clock, Language and Regional Settings, click on Change Date, Time and Number Format.
3. Click on Additional Settings
4. In the Number tab, make the Digit Grouping system to be comma. Check under the Number tab also
5. Click OK.
Kindly let me know if this works
- StanfordWhiteFeb 18, 2020Copper Contributor
Thanks for you feedback and help.
i did it as you wrote - but unfortunally is´s not gonna work!
when i open an excel file in the PREVIEW MODE, i can see it in the correct presentation, see here:
but if i open the same excel file properly in excel. it´s the same problem.... :
i guess excel does not use the country standard of the system preferences... and in excel i can´t go to the german country options... see here...
- Riny_van_EekelenFeb 18, 2020Platinum Contributor
StanfordWhite You need to go the the Advanced "Language § Region" setting in your Mac's System Preferences, as explained in my earlier post. Don't know the German, but look for the icon that looks like this:
I suspect that your setting is "-" as the thousands separator and "_" as the decimal like in the att picture below.
Excel will use these settings as the defaults.
- StanfordWhiteFeb 18, 2020Copper Contributor
thanks for your response.
i did this, beforehand. but this is still not the solution..
this are my setttings...