What you will build
You will check a spreadsheet’s Locale and Time zone settings, change them deliberately, and confirm that new date/number entries are interpreted using the selected regional settings without altering the source sample.
Learning objectives
Open the practice workbook
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Hands-on practice
Step 1: Open File > Settings. Use the visible File menu path; do not use command search. In the Settings dialog, locate both Locale and Time zone before changing anything.
Step 2: In Settings, choose the locale you want the spreadsheet to use and choose the intended time zone. Select Save settings. If Sheets reloads the workbook, wait for it to finish before entering new values.
Step 3: In an empty row, type one date and one number using the conventions of the locale you selected. Confirm that Sheets recognizes them as values rather than leaving them as plain text. Then remove the test row so the original A1:B3 sample remains unchanged.
Checkpoint
| Check | Expected result |
|---|---|
| Settings dialog | Locale and Time zone show the values you intentionally selected. |
| New date entry | Sheets interprets the date according to the selected locale’s date order. |
| New number entry | Sheets interprets decimal and thousands separators according to the selected locale. |
| Source sample | A1:B3 still contains the original Date text and Amount text rows. |
The locale setting controls regional parsing/formatting conventions for the spreadsheet; the time-zone setting controls the spreadsheet’s time context for time-sensitive calculations.
Common mistakes and fixes
Do not overwrite the original sample to force the expected appearance. Test in an empty row, verify how Sheets interprets the new entry, and then remove that temporary row.
Independent practice
Switch to a second locale, save the settings, and enter one temporary date and number using that locale’s conventions. Compare the interpretation with your first test, then restore the settings you want to keep.
Key takeaways
- ✓Spreadsheet Locale and Time zone are changed from File > Settings.
- ✓Locale affects regional conventions such as date order and number separators.
- ✓Time zone provides the spreadsheet’s time context for time-sensitive calculations.
- ✓Save settings and allow any reload to finish before testing new entries.
- ✓Verify changes with temporary entries instead of overwriting the source sample.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in the recommended learning order with Use right-to-left sheet layout.
Comments
No comments yet. Be the first to join the discussion.