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

 

[Gregm66]

lezawang i answered this in your first post,

check the date format of each cell make sure they are the same.
i produced the same style you have by changing the date format in each cell so as to reflect the dates in a different style..

 

[lezawang]

Thank you very much. The format of the 3rd row is Date, the format of the 5th row is Custom. But my question, why custom was selected as dd-mmm-yy.
Also still not sure why the 3rd one accept as a date when I entered yyyy-m-dd? thank you once again

 

[RoryA]

Please don’t post duplicate questions. This one is now closed and you may continue in the first one.