Search Images Maps Play YouTube News Gmail Drive More »
Sign in

Spreadsheets settings, views and printing

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:

  1. Open a spreadsheet.
  2. Click File > Spreadsheet settings.
  3. In the window that appears, you can change your time zone and locale.
  4. Click Save settings.

The changes will now be applied across the spreadsheet.

Tell us how we're doing - Answer five short questions about your help center experience