Forum Discussion
Andrewwong
Nov 23, 2021Copper Contributor
Date format in Excel
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
Riny_van_Eekelen
Nov 23, 2021Platinum Contributor
Andrewwong Well, select Custom and type mm/dd/yy in the "Type:" field.
Andrewwong
Nov 23, 2021Copper Contributor
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?
- Riny_van_EekelenNov 23, 2021Platinum Contributor
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.
- AndrewwongNov 23, 2021Copper ContributorRiny_van_Eekelen Yes, it can show whatever I entered. So no chance to change for less than 12? Thank you for your time!