My question is similar to Google Docs date in “dd/MM/yy” format and How can I change the input format for dates in Google Docs' spreadsheet?


unlike those answers, I'm trying to get the format with years first, which is non-ambiguous, more tech friendly and can be sorted alphabetically. I'm not aware of any locale that would put years first ?

Also, is it possible to automatically convert dates that would be typed with dd/mm/yyyy to yyyy/mm/dd ? (assuming my colleagues locale is indeed dd/mm/yyyy and NOT mm/dd/yyyy


1 Answer 1


I did not realize there was a "Format > Number > More formats > More date n Time formats" where I could specify the exact format I want, since the default date format is not what I am looking for.

It also handles auto-formatting of further inputs

  • but with only that it don't recognize "13/07/2021" as a valid date Jul 13, 2021 at 10:40
  • 1
    the rest depends on the language you have configured on the google sheet I believe Jul 13, 2021 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.