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:

  1. input, type NUMBER. The number to convert.
  2. 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"