Google Drive and Docs Tips

Click for larger image and screenshots

Spreadsheet Locale Setting

Change Locale in File > Spreadsheet Settings to ensure correct date format, currency and number format

This change is easy to make. Go to the File menu and select Spreadsheet Settings. Be aware that a document owner and any collaborators with Edit access can make this change to the spreadsheet - and it impacts the way the spreadsheet is seen be everyone. To change the default locale for all your spreadsheets, you can do so from Document Settings - click the cog in the top right corner and change the Language and Time Zone.

Comments/Feedback

Wayne Gemmell

Please add support for South Africa. Even if it is just the currency support.

26 February at 19:32 • Reply to this comment • Edit

Jaak Ennuste

You say that "This change is easy to make.." No, it's not. Country where I live and use my Drive, chromebook etc, Estonia, is missing entirely in Locale!? Why is that?

11 February at 21:33 • Reply to this comment • Edit

Mark Williams

Hi Bodey, It should work for all spreadsheets automatically - if you have changed the Language and Time Zone in your Drive Settings. gAppsTips

04 January at 09:40 • Reply to this comment • Edit

Bodey Baker

Any chance you're aware of a way to do this in a (logical) user based fashion?

04 January at 08:05 • Reply to this comment • Edit

When set, does it work for all your spreadsheets from then on?

07 February at 08:53 • Reply to this comment • Edit

Bodey Baker It doesn't seem to :'(

04 January at 07:55 • Edit