What you will build
You will diagnose a decimal and currency locale mismatch in Google Sheets, confirm the workbook locale, distinguish a number from locale-mismatched text, and apply a currency format to verified numeric cells.
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.
Sample data
| Displayed input | Stored value in this workbook |
|---|---|
| 1,234.56 | Number 1234.56 |
| 1.234,56 | Text under the United States locale |
The workbook locale is United States. Column B contains verified numeric 1234.56 values used for the currency-format check.
Hands-on practice
Step 1: Open File > Settings. Confirm that Locale is United States before interpreting commas, periods, or currency symbols.
Step 2: Compare A2 and A3. In this en_US workbook, A2 displays 1,234.56 and is stored as the number 1234.56, while A3 displays 1.234,56 and remains text because that punctuation does not match the current locale.
Step 3: Select B2:B3, then choose Format > Number > Currency. These cells are already numeric, so formatting should change only their display, not their stored value.
Step 4: Verify B2:B3 display $1,234.56. As a parsing check, temporarily re-enter A3 as 1,234.56; Sheets stores it as a number in this locale. Restore the original 1.234,56 text afterward so the sample remains unchanged.
Checkpoint
| Sample | Storage / result |
|---|---|
| A2: 1,234.56 | Numeric 1234.56 |
| A3: 1.234,56 | Text under en_US |
| B2:B3 | Numeric 1234.56 displayed as $1,234.56 |
Changing number format changes display only. If punctuation does not match the workbook locale, a pasted value may remain text instead of becoming a number.
Common mistakes and fixes
Correction: keep the original Text examples for diagnosis, work on confirmed numeric cells in column B, and verify both the stored value and the displayed currency format before moving on.
Independent practice
Add one temporary row. Enter a locale-mismatched value, observe whether Sheets stores it as text, then enter the equivalent value using the current locale punctuation. Remove the test row when finished.
Key takeaways
- ✓File > Settings reveals the workbook Locale that controls number, date, and currency interpretation.
- ✓In this United States workbook, 1,234.56 is numeric while 1.234,56 remains text.
- ✓Format > Number > Currency changes how a numeric value is displayed; it does not convert text into a number.
- ✓B2:B3 remain numeric 1234.56 and display as $1,234.56 after the currency format is applied.
- ✓When imported punctuation does not match the workbook locale, normalize the input or change locale intentionally instead of guessing.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order after you can distinguish locale-mismatched text from true numeric values.
Comments
No comments yet. Be the first to join the discussion.