Formualizer Docs
ReferenceFunctionsText Functions

DOLLAR

DOLLAR: Formats a number as currency text.

Summary

Formats a number as currency text.

Remarks

  • Default decimal places is 2 when omitted.
  • Negative values are rendered in parentheses, such as ($1,234.00).
  • Uses comma group separators and dollar symbol.
  • Input coercion failures or propagated errors return an error.

Examples

Default currency formatting
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
$1,234.50
Negative value with zero decimals
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
($999)

FAQ

How are negative numbers displayed?

Negative results are formatted in parentheses, for example ($1,234.00).

Runtime metadata

Category

Text

Signature

DOLLAR(arg1: Number, arg2?: Number)

Arity

min 1, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2optionaldefault

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/extended.rs

CONCATENATE

CONCATENATE: Legacy alias for `CONCAT` that joins multiple values as text.

EXACT

Compares two text values for exact equality.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are negative numbers displayed?Runtime metadata