FORMATNUMBER
The FORMATNUMBER function converts the input numeric value to a String representation for the specified country.
Input/Output
Number of Connections: 1
| Input | Data Type | Description |
| Input1 | Integer,Double,Decimal | The numeric value. |
| Output | Data Type | Description |
| Output1 | String | The String representation of the input. |
Property
| Name | Property Type | Description |
| Locale | choice | Defines the locale for which the input value is to be converted.
| System Locale [(default)]
| - |
Use the system's default locale.
|
|
Topic
- If the
Locale property is set to JAPAN or US, this function's output will be the same as the FORMATDECIMAL function where the Format property is set to "#,##0.###;-#,##0.###".
Example
| Property | Output |
| Input1 | 1234.5678 | Locale | US | 1,234.568 |
| Property | Output |
| Input1 | 1000000 | Locale | US | 1,000,000 |