DOLLAR Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

Use =DOLLAR(number, [decimals]) to turn a numeric amount into currency-formatted text; when decimals is omitted, the official default is 2. For example, in a US-English currency configuration, =DOLLAR(1234.567) is expected to display text resembling $1,234.57. This is not a numeric result you should pass directly into totals. ONLYOFFICE’s DOLLAR reference confirms the purpose, argument names and default; locale-specific punctuation is not fully specified there.

Use this function to assemble readable prices, invoices, exported notes or display-only summary labels. It is not a currency converter: it does not apply an exchange rate. It turns a number into formatted text. If you need a sortable or summable amount, keep the original numeric cell and apply the Spreadsheet Editor’s currency cell formatting instead. Microsoft’s analogous DOLLAR description also warns that text results can complicate arithmetic; this is cross-application context, not proof of exact ONLYOFFICE rendering.

=DOLLAR(number, [decimals])

There is one required argument and one optional argument. The function reference does not establish the behaviour of negative decimal-place counts, error coercion or binary midpoint ties for each ONLYOFFICE build; do not import Microsoft-specific guarantees without native tests. It also does not define every locale’s sign, grouping or currency-symbol placement. Official function page.

Evidence scope (accessed 2026-10-13): ONLYOFFICE’s current, unversioned English function index and the function reference. The reference confirms the syntax shown above but does not identify the first supporting release. The Docs changelog and Desktop Editors changelog are separate histories; neither was used to infer that every old Desktop version implements this function. Release histories and promotional banners do not establish a tested function-by-version matrix.

• Docs web/server Spreadsheet Editor: described in the official shared Spreadsheet Editor help; no native web/server execution performed for this guide.
• Desktop Editors: same general editor documentation is available, but the exact minimum Desktop version and behaviour in the target installation remain unverified.
• Mobile and integrations: not tested; do not assume parity from the shared function article.
• English formula examples: begin with =, use the English function name and comma-separated arguments. The Insert Function guide documents manual insertion. The Advanced Settings guide says formula language and region are configurable and that currency/decimal/grouping display can vary. Test translated function names, argument separators, region and numeric displays locally rather than assuming semicolons or comma decimals everywhere.

Enter the following as numbers, not quoted text:

For the exact output strings below, temporarily select English formula language and English (United States) region with period decimals, comma grouping and an ordinary $ display, then verify the cell’s effective currency behavior. The strings are illustrative independently reasoned expectations under that specific configuration, not native ONLYOFFICE output; a different region can produce different symbols, spaces or grouping.

1. Open a blank worksheet and enter the input cells exactly as listed; preserve the difference between typed text and numeric or logical values.
2. Enter the examples in free output cells, using a leading =. For formulas with more than one argument, use English comma separators in an English-formula configuration.
3. Compare the resulting values to the expected column. These expectations were checked from the official documentation and/or independent reasoning; none are results observed by running ONLYOFFICE.
4. Log the ONLYOFFICE product, version/build, online versus Desktop edition, operating system, chosen formula language and regional settings alongside any discrepancy.
5. Keep your source column; never overwrite original imported data until results are confirmed on your installation.

The ISTEXT and ISNUMBER checks provide an important audit: a formatted number looks financial but becomes text. If currency output varies in a target build, inspect numeric arguments separately before concluding that a calculation is wrong.

Keep numeric sales totals and show a formatted label separately

Place a numeric total in A2, then use =DOLLAR(A2,2) in B2 as a display-only label. Sum A2 and other original numeric cells, not the results of the DOLLAR formulas. The DOLLAR output is text by definition. Official DOLLAR and ISNUMBER.

Build a readable status sentence

="Current invoice total: "&DOLLAR(A2,2)

Expected under the specified locale: Current invoice total: $1,234.57. This is an independently reasoned text concatenation, not native execution. Be aware that changes to formula language, region or locale-specific currency signs may change the appearance of the label.

Choose formatting rather than a DOLLAR result for calculations

If the same amount must later be added, filtered as numeric or charted, prefer the original number in A2 and an applied currency display format. Only use DOLLAR in the presentation or export column. Related formatting function: TEXT; numeric formatting function: FIXED. These functions have different signatures and must not be treated as aliases.

1. Numbers no longer sum: DOLLAR returns text. Keep a numeric copy and use number formatting for the numeric workflow.
2. Wrong currency symbol or grouping: the Regional Settings controls formula language, region and separators. A DOLLAR label is not an exchange-rate conversion or a guarantee of Canadian-dollar notation.
3. Different rounding from a displayed cell: compare the original numeric amount, the optional decimals and the desired precision. Avoid assuming every midpoint behaves identically across applications; if needed, check with ROUND in the target build.
4. Negative amount looks different: account for currency negatives, parentheses and sign placement; the ONLYOFFICE function article does not fix one universal rendering. In A6, compare the native result with the expected numeric magnitude, but record its exact text as observed only after testing.
5. #NAME? or formula displayed literally: confirm the function is available in the installed build and is entered as an English formula (or use your translated Formula Language setting). Use the Insert Function dialog.
6. Unexpected decimal separators: ensure source cells are numeric, not text from imports. See NUMBERVALUE for deliberately interpreting regional numeric text.
7. Unsupported corner cases: the official DOLLAR article specifies the two arguments and default 2, but does not explicitly promise handling of negative decimal-place counts, TRUE, arrays or error values. These require target-version tests before publication claims.

The Excel DOLLAR documentation uses the same signature and describes locale-influenced currency display. That supports a related cross-application comparison, not a claim that ONLYOFFICE and Excel render identical strings for every locale or that their negative-decimal behaviour is identical. ONLYOFFICE DOLLAR reference is the authority for this guide.

Does DOLLAR actually convert USD into CAD? No. It formats a numeric input as currency text. No rate or currency-code argument exists in the documented syntax.

Why does SUM ignore my prices? The result is text. Leave amounts numeric for arithmetic, and create DOLLAR labels in a separate column only when you need text.

How many decimal places does it use automatically? The documented default is two, unless you supply decimals.

Can I rely on $ everywhere? No. Output appearance depends on locale and installation. Record the actual rendered output in your target edition during native review.

• ONLYOFFICE: DOLLAR syntax, argument purpose, default 2.
• ONLYOFFICE: Insert functions; Advanced settings: formula language and region.
• ONLYOFFICE: ISTEXT, ISNUMBER, TEXT, FIXED, ROUND, NUMBERVALUE.
• Microsoft Excel: DOLLAR (comparison only).

Official syntax and defaults were checked on 2026-10-13. Display strings are independently constructed illustrative US-English expectations. Native regional output, negative-decimal behavior, midpoint rounding and historical release support remain untested.