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

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

share|improve this answer
Can I change the locale for all documents including new ones? – romkyns Sep 27 '13 at 14:02
@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

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