Zoho Sheet DOLLAR Function: Locale-Aware Currency Text

Zoho’s official DOLLAR entry was retrieved on October 15, 2026. The entry documents the rolling web service; it does not establish the first introduction release or last functioning version. Both historical endpoints are unknown, and mobile/offline parity is unverified. The calculated expectations here are independent reference values, not captured native Zoho results.

DOLLAR(number; [decimals])

Number is required. Decimals is optional and defaults to 2. These examples use explicit nonnegative integer precision when it is not two. The checked entry does not establish negative precision, fractional precision coercion or a complete halfway-rounding rule.

The output is text. Keep a numeric source column for sums and comparisons, and apply the function at the presentation stage. Applying a currency symbol does not establish which currency the original amount represents.

The English help shows dollar signs, comma grouping, a decimal point and parentheses for a negative amount. Under that demonstrated presentation, the controls below have the listed text. In another locale, the symbol, separators or negative layout may differ; verify the workbook’s settings before treating a character-for-character mismatch as a calculation error.

Zoho’s original examples refer to hidden input cells. These formulas supply independent explicit values that reproduce those representations; they do not establish the content of the embedded source cells. None requires a disputed halfway-rounding decision.

Create Amounts with Amount in A1, Decimals in B1 and Display in C1. Enter the five rows below, and fill C2 =DOLLAR(A2;B2) through C6. This table assumes the help’s dollar/comma/point presentation solely for comparing text.

In a copy change B2 from 3 to 2. C2 becomes $12.50 in that presentation, while the number in A2 stays 12.5. The extra zero in the original string represented display precision, not an increase in the amount.

Suppose a fictional price list explicitly declares all amounts to be in USD. Put quantities 3 and 4 in F2:F3 and unit amounts 12.5 and 7.25 in G2:G3. Enter H2 =F2*G2 and fill through H3; the numeric line totals are 37.5 and 29.

In H5 enter =SUM(H2:H3), expected numeric 66.5. In I5 enter =DOLLAR(H5). Under the source presentation, the display is $66.50. The USD meaning came from the price-list specification, not from DOLLAR.

Change the second quantity F3 from 4 to 5. Its numeric line total becomes 36.25, and H5 becomes 73.75. I5 then displays $73.75 under the same presentation. This calculation keeps arithmetic in H and formatting in I, avoiding dependence on text-to-number coercion.

If a different source amount is explicitly denominated in EUR, changing a locale or currency symbol does not convert that amount to USD. A genuine conversion needs a supplied exchange rate, quote direction and date. DOLLAR accepts none of those arguments.

Likewise, a negative display in parentheses is a presentation convention, not a diagnosis of an account, refund or debt. Preserve a separate currency code and the signed numeric amount when preparing a machine-readable report. A symbol alone can be ambiguous across currencies and locales.

The official page supplies a shared name/type/reference error glossary without a function-specific numerical boundary table. Numeric-text coercion, blank handling, arrays and native locale behavior remain unverified. Do not import another product’s undocumented decimal-count limits into Zoho.

If the symbol is unexpected, check locale and the source currency field before changing the underlying number. If a total differs, inspect the numeric amount cells before inspecting the display strings. If an export loses formatting, verify the receiving application’s text interpretation.

For a numeric cell that only needs a currency appearance, a cell format may be more appropriate. DOLLAR deliberately creates text for a label or display layer; it is not an exchange-rate service, data-validation rule or native financial-system test.