16

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?

24

Under File > Spreadsheet settings....

File > Spreadsheet settings. Updated: Spreadsheet settings...

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

Spreadsheet Settings

Updated:

Locale nd Time zone

  • 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
  • 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
7

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

  • Thanks - good to know! (wonder why the GBs used was hidden :) – Anupam Mar 31 '18 at 8:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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