Problem with date format

Copper Contributor

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". Is there anyway for it to go back to the previous setting?

1 Reply

@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.