Spread Formula Reference
Formula Functions / Functions D to G / DOLLAR
In This Topic
    DOLLAR
    In This Topic

    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