USDOLLAR
Syntax:
USDOLLAR ( number [ , num-decimal ] )
Description: Produces a string containing number rounded to num-decimal decimal places. The thousands separator is the comma, the radix point is the period, and the currency symbol is "$". The format used is $#,##0.00;($#,##0.00).
Arguments:
Name |
Type |
Description |
---|---|---|
number |
number |
The number that is to be formatted. |
num-decimal |
number |
Designate the number of decimal places to be used in the resulting string; it is truncated to an integer. If num-decimal is negative, number is rounded to the left of the decimal point. If omitted, a value of 2 shall be assumed. |
Return Type and Value: text – The string containing number rounded to num-decimal decimal places, and have a currency symbol and thousands separators.