Forum Discussion
Date Format in EXCEL for the Web
"I added a data validation rule into a column of a worksheet created and successfully tested in EXCEL for Windows. Only Dates after 1. August 2023 should be accepted. The Region of the Worksheet and my Computer is set to Germany.
When I enter a date e.g. 2.3.24 ( = 2 March 2023) into Excel for the Web, I get the message, that only dates after 08/01/2023 are accepted.
It appears that Excel for the Web expects the date in the format mm/dd/yyyy, but I would like to enter it in the format dd.mm.yyyy.
How can I adjust this behavior in Excel for the Web?"
You may change regional settings in Excel for web in File -> Options Change regional format settings in Excel for the web - Microsoft Support
That will be your personal regional settings. If such format required for entire organization, ask your admins to change regional settings for SharePoint sites / OneDrive on tenant level.
By default during setup US regional settings are applied.