Forum Discussion
heinzmutzner
Sep 23, 2024Copper Contributor
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...
SergeiBaklan
Sep 23, 2024Diamond Contributor
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.