Date format in Excel

[Andrewwong]

Anyone can tell me why my excel doesn't have mm/dd/yy format can be chose from? I can only found mm-dd-yyyy or mm-dd-yy 1:30 PM

[#2]

@Andrewwong Well, select Custom and type mm/dd/yy in the "Type:" field.

[#3]

Thank you, but after did that, I can type 1/6 to become 1/6/21 but if I typed 1/6/22, it became 06/22/01, why?

[#4]

@Andrewwong That's probable due to your locale setting. Try with a date where one of the numbers is greater than 12 as 1/6 can be 1 June or January 6.

[#5]

@Riny_van_Eekelen Yes, it can show whatever I entered. So no chance to change for less than 12? Thank you for your time!