Nov 23 2021 09:19 AM
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
Nov 23 2021 09:26 AM
@Andrewwong Well, select Custom and type mm/dd/yy in the "Type:" field.
Nov 23 2021 09:36 AM
Nov 23 2021 10:00 AM
@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.
Nov 23 2021 10:20 AM