Date format in excel

[lezawang]

Hi
My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted

yyyy-m-dd as a date and why accepted sept 14, 2019 as a date and changed to 14-sept-2019. but why did not change it to 14-09-2019 (why 09 changed to sept). Thank you very much


[TABLE="width: 358"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]I typed[/TD]
[TD]press enter[/TD]
[/TR]
[TR]
[TD]14-09-2019[/TD]
[TD="align: right"]14/09/2019[/TD]
[/TR]
[TR]
[TD]9-14-2019[/TD]
[TD]9-14-2019[/TD]
[/TR]
[TR]
[TD]2019-9-14[/TD]
[TD="align: right"]14/09/2019[/TD]
[/TR]
[TR]
[TD]2019-14-9[/TD]
[TD]2019-14-9[/TD]
[/TR]
[TR]
[TD]sept 14, 2019[/TD]
[TD="align: right"]14-Sep-19[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gregm66]

Hi lezawang,

Just a guess here but have you checked the date format for each cell?
are they the same as the format type in the cells that ypu typed in..