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


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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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