FormatNumber
This function rounds decimal numbers up if the specified format uses fewer decimal points than the value itself and the remaining numbers are 5 or greater. The function rounds decimal numbers down if the specified format uses fewer decimal points than the value itself and the remaining numbers total less than 5. Integers outside the range of -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 print in scientific notation.
FormatNumber(1, 2, 3)
Ordinal | Type | Description | |
---|---|---|---|
1 | numeric | Required | Value to receive the specified formatting. |
2 | string | Required | Valid format type value:
|
3 | string | Culture code used to indicate the correct date format |
Example 1
System returns this value:
Example 2
System returns this value: