DOLLAR in Google Sheets: Currency Text and Locale Checks

• Introduced: first introduction date is not established by the reviewed official history; no desktop release number is inferred.
• Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
• Checked: October 14, 2026; official DOLLAR reference. Documentation and independent models, with no native Sheets execution or wider client certification.

=DOLLAR(number,[number_of_places])

The currency style comes from the spreadsheet’s locale. A collaborator’s physical location does not independently select a different currency for the same file. Google explains the shared setting in its spreadsheet location settings reference.

The examples below use a U.S.-locale display model with a dollar sign, comma grouping and decimal point. They use positive amounts and nonnegative decimal counts; the short dedicated reference does not establish negative-precision behavior, every negative-currency style or exact native midpoint errors.

DOLLAR is a formatting function, not an exchange-rate service. A symbol attached to 25 does not change the amount according to another currency’s value.

Enter these numeric values in A2:A5. In B2 enter =DOLLAR(A2,2) and fill through B5:

The expected rounded magnitudes are independently calculated to hundredths. The first value becomes 1850.25, while the third becomes 0.08. Trailing zeros in the second and fourth strings make the requested display precision visible.

In C2 use ="Amount due: "&B2. Its output is Amount due: $1,850.25. Copying the formula down produces a text label for each original amount without replacing the numeric source column.

With A2=1850.246:

The first two agree because the documented default is 2. The count describes decimal places, not significant digits or the number of digits before the decimal point.

Use a deliberately chosen output precision for a report. Merely displaying three decimals does not prove that the original measurement or amount was accurate to that precision.

In D2 use =TO_DOLLARS(A2). Both B2 and D2 may look like currency, but Google documents different output types.

=ISTEXT(B2) returns TRUE and =ISNUMBER(B2) returns FALSE for the DOLLAR string. =ISNUMBER(D2) returns TRUE because TO_DOLLARS retains the numeric value. The original amount behind D2 remains 1850.246 even when its currency display shows two decimal places.

Use A or the numeric D column for sums and comparisons. A text presentation should not silently become the source of a financial calculation. A later text-to-number conversion also depends on interpreting the punctuation and currency symbols correctly.

Enter 12.004 in E2:E4. Each =DOLLAR(E2,2) result, copied down, is $12.00 in the stated display model.

The original numbers total 36.012, so:

=DOLLAR(SUM(E2:E4),2)

gives $36.01. If each numeric row is first rounded with =ROUND(E2,2), the three rounded amounts instead total 36.00. These are different operation orders, not inconsistent addition.

Keep the raw amounts and state which rounding order the report requires. This example explains the arithmetic; it does not decide an accounting policy for the workbook.

If a collaborator sees an unexpected currency symbol, inspect the file’s locale and intended currency before changing the data. Changing shared locale settings can also affect date and number presentation elsewhere in the spreadsheet.

Use TO_DOLLARS for numeric currency formatting, ROUND for a numerical rounding step, and TEXT for a chosen display pattern. Preserve the original numeric column for auditability. Native errors for invalid precision types and extreme values remain outside the checked examples.

• Google DOLLAR reference.
• Editorial testing standards.

Examples use fictional data, English function names and comma separators. Expected outputs are independent mathematical calculations or explicitly documented rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.