Forum Discussion
Excel default date display
Windows 11. The default date display is in the format. 6.12.2021 ( Finish=Suomi) When I enter Excel 6/12 - excel shows it on 6.joulu I would always like it to show by default on 6.12.2021 (i.e. th...
If the cell has not yet been formatted as a date, and if you only enter the day and month, Excel will automatically apply a format with only the day and month. You cannot change that.
It's best to format the range with the desired date format before starting to enter dates. (Or include the year - it doesn't matter whether you use 2 or 4 digits for the year)