Oct 31 2021 12:00 AM
Dear all,
It seems that language change for Windows from German to French is causing an issue in my date format in Excel. See the attached Excel sheet. Date appears with , instead of . Cannot change it or get rid of it. Help on Google search did not return a result.
Many thanks in advance for your assistance!
Kind regards
Cheffounet
Oct 31 2021 03:07 AM
Language and region settings in Office 365 can be set using PowerShell Set-MsolUser PreferredLanguage.
Details in the upper Link.
Additional Infos:
Excel Dates Displayed in Different Languages
Hope I was able to help you with this info.
Oct 31 2021 03:14 AM
@NikolinoDE thanks for your answer, however, this is not at all what I was looking for...
Please have a look to the attached Excel sheet. All of the sudden, new date entries are displayed with a "," although I am typing a ".".
In my opinion, this might be related to a recent change of Windows language from German to French.
It is clearly a bug in Excel... no way to find any instruction to correct this... quite annoying!!!
Kind regards
Cheffounet