DOLLAR Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc DOLLAR, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
Converts a number to text in currency format. With the test locale, 1234.5 formatted to two currency decimals becomes $1,234.50, as a text string.
Syntax and arguments
=DOLLAR(Value; Decimals)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
Value |
Value is a number, a reference to a cell containing a number or a formula that results in a number. |
Decimals |
Decimal places. Denotes the number of digits to the right of the decimal point. (optional) |
Worked examples
Example 1: Format a number as currency text in an English-language locale
=DOLLAR(1234.5;2)
Expected result: $1,234.50. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
With the test locale, 1234.5 formatted to two currency decimals becomes $1,234.50, as a text string.
Mistakes and troubleshooting
- Check inputs and assumptions: Currency symbols and thousands separators depend on locale. Use number formatting if the value must remain numeric.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
1 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.