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

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.


A quick disclaimer...

Although I put in a great effort into researching all the topics I cover, mistakes can happen. Use of any information from my blog posts should be at own risk and I do not hold any liability towards any information misuse or damages caused by following any of my posts.

All content and opinions expressed on this Blog are my own and do not represent the opinions of my employer (Oracle). Use of any information contained in this blog post/article is subject to this disclaimer.
Hi! You can search my blog here ⤵
NOTE: (2022) This Blog is no longer maintained and I will not be answering any emails or comments.

I am now focusing on Atari Gamer.