Forum Discussion

heinzmutzner's avatar
heinzmutzner
Copper Contributor
Sep 23, 2024

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?"

Resources