Forum Discussion

Copper Contributor

Feb 12, 2020

MS OFFICE 2019 / Dezimaltrennzeichen / Mac Betriebssystem Mojave

Hallo Zusammen, ich bin von Mac Beriebssystem High Sierra auf Mojave umgestiegen und somit auch von von meinem MS Office Paket für Mac auf MS Office 2019. Das Btriebssystem wurde mit der Ländereinst...

excel

Formulas and Functions

StanfordWhite

Copper Contributor

Feb 18, 2020

Abiola1

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_Eekelen

Platinum Contributor

Feb 18, 2020

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.

StanfordWhite
Copper Contributor
Feb 18, 2020
Riny_van_Eekelen

thanks for your response.

i did this, beforehand. but this is still not the solution..

this are my setttings...
- Riny_van_Eekelen
  Platinum Contributor
  Feb 18, 2020
  StanfordWhite Did some experimenting and noticed that you must restart Excel after you changed the system settings. After restarting, formatting of numbers and currency should follow the system settings. Works for me. If it doesn't work for you, I'm lost. Sorry!
  - StanfordWhite
    Copper Contributor
    Feb 18, 2020
    Riny_van_Eekelen
    
    well this is also not working here at my MAC BOOK AIR.
    
    i hope / cross fingers that maybe someone else got the key.
    
    thanks