The Living Deadline

Finding the Right Locale for Google Spreadsheets: Currency and Date

I was collaborating with Google Spreadsheets when I encountered a particular annoyance regarding currency and date formats.

If you go to File > Spreadsheet Settings you will find, in the General tab, the possibility of choosing what locale you want to choose.

Google Spreadsheets Locale Menu - Argentina is Selected

The problem was that we wanted the little endian (day, month, year) or big endian (year, month, day) date format instead of the awkward middle endian (month, day, year) format (Common in places like USA or Canada).

We also wanted the dot operator as currency since the default layout for most keypads involves a dot instead of a comma, even in countries that use the comma operator for decimals.

Image of Typical Keypad - Done with https://www.keyboard-layout-editor.com/

After searching for a bit we came to a nice compromise in the lovely country of Australia which allows us to use the best of both worlds and where the currency still shows a generic $ money sign.

Thanks Australia!

There are comments.

links

social