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

Syntax

DOLLAR(number,digits)

Arguments

This function has the following arguments:

Argument	Description
number	Refers to the numeric value to convert to text using the currency format
digits	[Optional] Refers to the number of decimal places to maintain; if negative, the value is rounded to the left of the decimal point; if omitted, the system locale setting is used to determine the number of decimal places

Remarks

This function always shows U.S. currency.

Data Types

Accepts numeric data for both arguments. Returns string data.

Examples

USDOLLAR(A5,B2)

USDOLLAR(R1B2,R3D4)

Version Available

This function is available in Spread for Windows Forms 11.0 or later.