Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

This question already has an answer here:

Is there any way to use date in format dd/MM/yy? The Google Docs support only MM/dd/yy and it cause us problems to use it (we can't sort the date column).

share|improve this question

marked as duplicate by Al E., Jacob Jan Tuinstra, jonsca Dec 12 '13 at 21:16

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Wow this was hard to find! Some keywords: Google Calendar European date format for date/time columns. – romkyns Dec 4 '12 at 3:03

2 Answers 2

I guess you're talking about Google Spreadsheets.

You can do that if you go to FileSpreadsheet settings... and change the Locale:

google spreadsheet settings

share|improve this answer
Can I change the locale for all documents including new ones? – romkyns Sep 27 '13 at 14:02
@romkyns Yes. – Ekevoo Nov 6 at 5:11

To change the date format to dd/mm/yy - go to your Google Apps gear wheel -> settings -> Language -> click the drop down box and select English (UK) - that gets you dd/mm/yyyy by default. Sorry if you are anything but British, but that seems the best way to do it as a user. I'm trying to do it for a whole domain to save users using different date formats and getting snarled up - not found how to do it yet!

There is a setting in Google Admin control panel -> Domain settings -> Language, which I've set to English (UK), but I've noticed one of my users is still coming up showing mm/dd/yyyy format. Meh.

share|improve this answer
How does your answer differ to that already given? – Jacob Jan Tuinstra Jan 28 '13 at 6:31