number
Use the number function to convert a number into a formatted textual representation. The number is formatted according to the current output language.
This function returns a value of type TEXT.
The function has two parameters:
- input, type NUMBER. The number to convert.
- precision, type NUMBER. The number of decimal positions to display.
If input has a fractional part, it is rounded to the nearest value with the specified precision. The precision is limited to 9 digits.
Examples
number (1234567; 0) results in "1,234,567"
number (1234567; 2) results in "1,234,567.00"
number (1234567; 2) results in "1.234.567,00" (output language "NLD")
number (123.435; 4) results in "123.4350"
number (123.435; 2) results in "123.44"
number (123.435; 0) results in "123"