DOLLAR in Collabora Office: Create Currency Text without Changing the Quantity

• Introduced: the original Collabora release and launch date are not established by the reviewed sources.
• Availability: documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployment support is not inferred from the desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent controls; no native Collabora execution.

=DOLLAR(Value [; Decimals])

Value may be a number, a cell reference or a formula returning a number. Decimals is optional and defaults to two. The currency format and decimal separator depend on the current settings. Despite its name, DOLLAR does not always print a US dollar sign.

The official example uses the same numeric 255 with three settings: $255.00 for English (USA)/USD, ￥255.00 for Japanese/JPY and 255,00 € for German (Germany)/EUR. Those are formatting examples, not currency conversions or exchange rates.

Use English (USA) locale with USD for the following labels. Keep the numeric source cells available for arithmetic. A number format applied directly to a numeric cell is a different workflow: it can change appearance without creating a text result.

Enter only the first column in A2:A5. Calculate B with =DOLLAR(A2;2) filled down.

The first two values land exactly halfway between hundredths. Their displayed labels round upward for these positive controls. The other two demonstrate trailing zeros, which are part of the currency label rather than additional measurement precision.

For a more detailed report, use =DOLLAR(A2;3), giving $18.125 on the first row. Omitting Decimals gives the documented two-place format: =DOLLAR(6.5) has expected result $6.50.

The numeric input 18.125 has not become 18.13 simply because B2 displays that rounded text. Check A2 when a downstream calculation needs the original quantity.

Enter unit prices 12.5, 7.25 and 3.125 in D2:D4, and quantities 4, 6 and 8 in E2:E4. In F2 enter =D2*E2 and fill down. The numeric extensions are 50, 43.5 and 25.

In G2 use =DOLLAR(F2;2) and fill down. Expected labels are $50.00, $43.50 and $25.00. Total the numeric extensions with =SUM(F2:F4), giving 118.5, then format the total with =DOLLAR(SUM(F2:F4);2), giving $118.50.

This design keeps calculation and presentation separate. It avoids depending on whether another formula happens to coerce currency text back to a number in a particular locale.

Enter 0.125 in J2 and J3. Each individual label from =DOLLAR(J2;2) is $0.13. But =DOLLAR(SUM(J2:J3);2) is $0.25, since the unrounded numeric total is one quarter.

If a report specification requires each numeric line to be rounded before summation, calculate that policy explicitly:

=ROUND(J2;2)+ROUND(J3;2)

The independently expected numeric result is 0.26, whose currency label is $0.26. This is a different rounding policy, not a failure of DOLLAR. ROUND changes the numeric result; DOLLAR creates the display text.

For the primary fixture, =ISTEXT(B2) is expected TRUE and =ISNUMBER(A2) is TRUE. ISTEXT and ISNUMBER help audit which column is suitable for arithmetic.

The dedicated DOLLAR page does not establish negative or fractional Decimals behavior, invalid-type errors, currency-position variations for every locale or native binary-rounding limits. Those are not borrowed from another spreadsheet. FIXED is useful when you want decimal text without a currency symbol; its own separator/default rules should be checked separately.

• Collabora Office 26.04: DOLLAR.
• Editorial testing standards.

Complete dedicated product documentation reviewed. Outputs are independent decimal, positional, character or type models, or explicit vendor controls; no native Collabora execution. Formulas use English names and semicolon separators. Optional-argument brackets describe syntax and are not typed into working formulas.