DOLLAR

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

DOLLAR(value,digits)

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

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

Accepts numeric data for both arguments. Returns string data.

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

This function is available in product version 1.0 or later.