The FORMATNUMBER function converts the input numeric value to a String representation for the specified country.
Input | Data Type | Description |
---|---|---|
Input1 | Integer,Double,Decimal | The numeric value. |
Output | Data Type | Description |
---|---|---|
Output1 | String | The String representation of the input. |
Name | Property Type | Description |
---|---|---|
Locale | choice | Defines the locale for which the input value is to be converted. If (default) is selected, the system's default is used. |
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.###".Property | Output | |||
Input 1 | 1234.5678 | Locale | US | 1,234.568 |
Property | Output | |||
Input 1 | 1000000 | Locale | US | 1,000,000 |