dollar

Format a number as currency text.

Syntax

v = dollar(number, decimals)

Description

Returns number formatted with the local currency symbol and decimals digits after the decimal (default 2). Equivalent to text(number, '$#,##0.00') in en-US locale.

Example

dollar(1234.567)        % '$1,234.57'

See also

• fixed — Format a number with a fixed number of decimal places.
• text — Format a number as text using an Excel-style format.