Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The input string for dates in Google Docs's spreadsheet app seems to be set to en_US, which is quite unnatural to me.

How can I change the input format?

share|improve this question
up vote 14 down vote accepted

Under File > Spreadsheet settings....

File > Spreadsheet settings. Spreadsheet Settings

Select the locale with the date format you want (for example US is mm/dd/yyyy and UK is dd/mm/yyyy).

share|improve this answer
That's a Calendar, not Google Docs setting. – Robert Munteanu Aug 9 '10 at 10:33
Changed to show Docs instead of Calendar (same system for selection). – Metalshark Aug 9 '10 at 11:12
Aha! Thank you. – Robert Munteanu Aug 9 '10 at 11:17
Is there any english speaking locale that uses yyyy-mm-dd international format? – cregox Sep 12 '15 at 20:40
Is there any english speaking locale that uses mostly the yyyy-mm-dd international format? Looks like Canada (English) might do the trick, but it's a bit confusing as it also accept other standards. – cregox Sep 12 '15 at 20:55

The answer from @Metalshark is great for updating existing documents, but I'd also like to point out that this can be set as a default.

Click the gear icon on the right from your main Google Drive dashboard and select Settings. If you don't have a language selected you can set it here. This should apply to all future documents.

Google Drive language setting

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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