The FORMATCURRENCY function converts the input numeric value to a String representation for the specified country's currency.
Input | Data Type | Description |
---|---|---|
Input1 | Integer,Double,Decimal | The numeric value. |
Output | Data Type | Description |
---|---|---|
Output1 | String | The converted input value's String representation for the specified country's currency. |
Name | Property Type | Description |
---|---|---|
Locale | choice | Defines the locale for which the input value is to be converted. If (default) is selected, then the system's default is used. |
Locale
property is set to JAPAN, this function's output will be the same as the FORMATDECIMAL function where the Format
property is set to "¥#,##0;-¥#,##0".Locale
property is set to US, this function's output will be the same as the FORMATDECIMAL function where the Format
property is set to "$#,##0.00;($#,##0.00)".Property | Output | |||
Input 1 | 1234.5678 | Locale | US | $1,234.57 |