How can I change the input format for dates in Google Docs' spreadsheet?

Question

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?

Metalshark · Accepted Answer · 2010-08-09 11:13:14Z

up vote 5 down vote accepted

File > Spreadsheet settings.

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

edited Aug 9 '10 at 11:13

answered Aug 9 '10 at 7:45

Metalshark
54434

	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

1 Answer