Igor Kromin |   Consultant. Coder. Blogger. Tinkerer. Gamer.

NOTE: This article is 3 years or older so its information may no longer be relevant. Read on at your own discretion! Comments for this article have automatically been locked, refer to the FAQ for more details.
I use Google Documents a fair amount and recently have been really bothered by the fact that it was not recognising the dates I put in (in the Australian format) or worse it was making dates appear completely different. This was an obvious locale problem, so I went for a look around and this is how you fix it.

To explain this better, here's an example of what was happening:

Putting in a date like '9/4/14' should make the spreadsheet show it as '9th April 2014', instead it was being shown as '4th September 2014'. This is because the US and Australian date formats swap the month and day around. This was making each of the dates I put in out of whack or they were simply not being picked up as valid dates.

The solution is quite simple.

To fix this for good, you need to update the Language for your Google profile by selecting Australia as the Language Variant. For some reason mine was set to United States, and that was causing my dates to go crazy.

Now the above setting will only affect new spreadsheets you make, so to fix your existing spreadsheet, you need to update the settings on that spreadsheet itself. This is found in the File menu when the spreadsheet is open.

Change the locale to Australia.

What I found interesting is that the existing dates are transformed to be in the new format, so my original '9/4/14' entry got changed to '4/9/14' to match the new locale, this is great! Entering new dates now the spreadsheet treats them the way I wanted to in the first place.


Skip down to comments...
Hope you found this post useful...

...so please read on! I love writing articles that provide beneficial information, tips and examples to my readers. All information on my blog is provided free of charge and I encourage you to share it as you wish. There is a small favour I ask in return however - engage in comments below, provide feedback, and if you see mistakes let me know.

If you want to show additional support and help me pay for web hosting and domain name registration, donations, no matter how small, are always welcome!

Use of any information contained in this blog post/article is subject to this disclaimer.
comments powered by Disqus
Other posts you may like...