DOLLAR
Converts a number to text, using the $ (dollar) currency format.
TextText Processing
What it does
Converts a number to text, formatted as currency with specified decimals.
Syntax
DOLLAR(number, [decimals])
Arguments
number(number) — The number to convert.decimals(number) — Number of digits to the right of the decimal point.
Examples
Format as Currency
Format 1234.567.
FORMULA
=DOLLAR(1234.567, 2)
RESULT
$1,234.57
SAMPLE DATA
| A | |
|---|---|
| 1 | Value |
| 2 | 1234.567 |