Forum Discussion
Problem with date format
Usually when I type "1-15" it automatically converts to "01/15/2023" as long as I have the cell in a date format. Something happened recently and whenever I type "1-15", it converts to "01/01/2015". ...
Gyvs127 Check the regional settings on your system and make sure that the date format is set to mm/dd/yyyy. Then Excel will recognise 1-15 as January 15, 2023, otherwise it will not and indeed return 1 January 2015.