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 |