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).
-
1Wow this was hard to find! Some keywords: Google Calendar European date format for date/time columns.– RomanStCommented Dec 4, 2012 at 3:03
-
Wondering exactly the same thing!! You should make below your answer.– BBkingCommented Dec 3, 2015 at 3:10
Add a comment
|
2 Answers
I guess you're talking about Google Spreadsheets.
You can do that if you go to File → Spreadsheet settings... and change the Locale:
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.
-
2
-