Spread Formula Reference
Formula Functions / Functions T to Z / USDOLLAR
In This Topic
    USDOLLAR
    In This Topic

    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.