Google Sheets web app (rolling service) · Workbook essentials · Beginner
Set locale, time zone and calculation settings in Google Sheets
Set locale, time zone and calculation settings in Google Sheets with a worked fixture, expected results and safe recovery.
Documentation-reviewed candidate; native application verification not performed. · Editorial standards
Quick answer
Use File > Settings to set the spreadsheet’s locale and time zone, then inspect the Calculation tab for calculation mode. These are workbook-wide settings, not personal viewing preferences. Test them in a private copy before changing a shared operational file.
Know which setting owns the symptom
This walkthrough is for editable native Google Sheets in the desktop web app. Google’s documentation captured on 20 October 2026 describes Automatic and Manual calculation modes; manual mode is editor-only and unavailable in the mobile app. A rolling service can differ across accounts, so use the controls actually available and do not substitute an older timer setting for a mode that is absent.
Locale controls default number, currency and date presentation. Time zone belongs to the spreadsheet, not necessarily the device. Neither setting translates the interface language. Function language is a separate setting, linked to the account’s display language and the Always use English function names choice.
The safe outcome is a file with explicitly recorded settings and a verified dependent calculation, not a promise that changing locale repairs already-misinterpreted data.
Establish a reproducible baseline
Make a private copy first and record its original locale, time zone and calculation mode. In that copy, open File > Settings > General, choose United States as the locale and a UTC/GMT time-zone entry shown by the selector, then click Save settings. Reopen Settings to verify what was actually saved.
Enter the following cells only after that baseline is set:
| Cell | Entry | Expected meaning |
|---|---|---|
| A1 | 5 | Numeric input |
| B1 | =A1+10 | Dependent result, initially 15 |
| A3 | 1234.5 | Numeric amount, not a currency conversion |
| A5 | 10/20/2026 | Date entered under US locale |
Use an unambiguous date whose day exceeds 12, and inspect that Sheets recognizes it as a date rather than text. Do not use a date string such as 04/05/2026 to prove an interpretation without checking it.
Compare locale deliberately
In the practice copy, change Locale to United Kingdom and save. Inspect the default date/currency behavior, then reopen Settings and verify the locale. Existing custom formats may remain deliberate overrides, so unchanged appearance alone does not prove the setting failed. The date should still represent 20 October 2026, and the amount should still represent the same numeric quantity.
Do not retype or swap day/month components merely to force a familiar display. Restore United States when finished if that is your final intended file convention. Record the final locale and time zone in a small note in A7 so collaborators know the assumption used in the exercise.
Verify calculation mode with a dependent cell
- Open File > Settings > Calculation.
- Select Automatic mode and save settings.
- Change A1 from 5 to 7. B1 should become 17 because it depends on A1.
- If Manual mode is available, select it in the same settings location and save. Check for the manual-mode reminder banner.
- Change A1 from 7 to 9. Do not treat the displayed result as refreshed until you choose Calculate at the top of the screen. After Calculate, B1 should be 19.
- Restore Automatic mode, set A1 back to 5 and verify B1 returns to 15.
If Manual is unavailable, finish with the verified Automatic result and record that branch as unavailable. Do not claim to have run the manual comparison. The final file should not be left in an experimental mode that surprises another editor.
Troubleshooting and recovery
An unchanged formula may have no dependency on the edited cell; test with B1 rather than an unrelated number. External-data functions have their own update behavior, so Calculate is not a guarantee that an external service has fresh data. For imported data and date-range boundaries, use the separate timestamp query guide.
Reopen the final copy to confirm the saved settings and B1 = 15. If a locale experiment misinterpreted new entries, recover the inputs from the untouched original; changing the locale back does not reliably reconstruct what you meant to type. Never use a workbook-wide setting change as an unexplained fix in someone else’s shared file.
Official references
Documentation basis: first-party help snapshots captured 20 October 2026. Fixture arithmetic and stated changes were checked independently. No native Google Sheets session, Excel round trip, screenshot, sharing action or export was executed for this article.