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).

  • Wow this was hard to find! Some keywords: Google Calendar European date format for date/time columns. – RomanSt Dec 4 '12 at 3:03
  • Wondering exactly the same thing!! You should make below your answer. – BBking Dec 3 '15 at 3:10

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

| improve this answer | |
  • 1
    Can I change the locale for all documents including new ones? – RomanSt Sep 27 '13 at 14:02
  • 1
    @romkyns Yes. webapps.stackexchange.com/a/45775/28950 – Ekevoo Nov 6 '15 at 5:11
  • Thanks, champion!! Who would have thought!?!? I went through date formatting and it still wasn't working. THIS is what fixed it... – BBking Dec 3 '15 at 3:11
  • Does only work when all sheets have the same date format... – bart Sep 3 '16 at 5:24

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.

| improve this answer | |
  • 2
    How does your answer differ to that already given? – Jacob Jan Tuinstra Jan 28 '13 at 6:31
  • Does only work when all sheets have the same date format... – bart Sep 3 '16 at 5:24