Skip to main content
format-number Format: Number, takes the input and applies number formatting to it. Several input arguments can be used to get the desired result.

Fields

Number of decimals

Required, the number of decimals used in the output. Will round up if needed

Separator for the decimal point

Required, What character(s) to use for the decemal point.

Separator for the thousands separator

The character used for thousands separator. Default nothing.

Sample data

Input data1000000
Number of decimals2
Separator for the decimal point,
Separator for the thousands separator.
Output data1.000.000,00