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

I typed	press enter
14-09-2019	14/09/2019
9-14-2019	9-14-2019
2019-9-14	14/09/2019
2019-14-9	2019-14-9
sept 14, 2019	14-Sep-19

<colgroup><col><col></colgroup><tbody>
</tbody>

 

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