Change locale, date format and currency settings
Any collaborator can change the locale settings for a spreadsheet. Doing so will change the spreadsheet's default currency, date format and number formatting. Be advised that when this change is made, it's implemented across the spreadsheet and impacts everyone working on it, regardless of geographic location.
If you're an owner or collaborator, you can change the locale and time zone by following these steps:
- Open a spreadsheet.
- Click File > Spreadsheet settings.
- In the window that appears, you can change your time zone and locale.
- Click Save settings.
The changes will now be applied across the spreadsheet.