FORMATCURRENCY
The FORMATCURRENCY function converts the input numeric value to a String representation for the specified country's currency.
Input/Output
Number of Connections: 1
| 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. |
Property
| Name | Property Type | Description |
| Locale | choice | Defines the locale for which the input value is to be converted.
| System Locale [(default)]
| - |
Use system's default locale.
|
|
Topic
- If the 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".
- If the 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)".
Example
| Property | Output |
| Input 1 | 1234.5678 | Locale | US | $1,234.57 |