Spread Formula Reference
DOLLAR
Formula Functions > Functions D to G > DOLLAR

This function converts a number to text using currency format, with the decimals rounded to the specified place.

Syntax

DOLLAR(value,digits)

Arguments

This function has these arguments:

Argument Description
value Numeric value to convert to text using the currency format
digits [Optional] Number of decimal places to maintain; if negative, the value is rounded to the left of the decimal point; if omitted, the function rounds to two decimal places

Remarks

This function uses the current regional Windows settings to determine the format of the returned string.

Data Types

Accepts numeric data for both arguments. Returns string data.

Examples

DOLLAR(B5,D2)

DOLLAR(R5C2,R2C4)

DOLLAR(1234.5678,3) gives the result $1,234.568

DOLLAR(123.45,1) gives the result $123.5

Version Available

This function is available in product version 1.0 or later.

See Also

DOLLARDE | DOLLARFR | FIXED | Text Functions