NUMBERFORMAT
Returns the provided number formatted based on the given format.
js
NUMBERFORMAT(input_number, format)Parameters
input_number- The number to be processed.format- The format to use.
Examples
js
NUMBERFORMAT(1234567.89, "#,##0.00")Result: 1,234,567.89
js
NUMBERFORMAT(1234567.89, "#,##0.0")Result: 1,234,567.9
js
NUMBERFORMAT(1234567.89, "#,##0.000")Result: 1,234,567.890
js
NUMBERFORMAT(1234567.89, "#,##0.0000")Result: 1,234,567.8900
js
NUMBERFORMAT(1234567.89, "#,##0.00000")Result: 1,234,567.89000
js
NUMBERFORMAT(1234567.89, "#,##0")Result: 1,234,568
js
NUMBERFORMAT(1234567.89, "#,##0k")Result: 1,235k
js
NUMBERFORMAT(1234567.89, "#,##0.0k")Result: 1,234.6k
js
NUMBERFORMAT(1234567.89, "#,##0.00k")Result: 1,234.57k
js
NUMBERFORMAT(1234567.89, "#,##0.000k")Result: 1,234.568k
js
NUMBERFORMAT(1234567.89, "#,##0m")Result: 1m
js
NUMBERFORMAT(1234567.89, "#,##0.0m")Result: 1.2m
js
NUMBERFORMAT(1234567.89, "#,##0.00m")Result: 1.23m
js
NUMBERFORMAT(1234567.89, "#,##0.000m")Result: 1.235m
js
NUMBERFORMAT(1234567890, "#,##0b")Result: 1b
js
NUMBERFORMAT(1234567890, "#,##0.0b")Result: 1.2b
js
NUMBERFORMAT(1234567890, "#,##0.00b")Result: 1.23b
js
NUMBERFORMAT(1234567890, "#,##0.000b")Result: 1.235b
js
NUMBERFORMAT(0.123, "0.000%")Result: 12.300%
js
NUMBERFORMAT(0.123, "0.00%")Result: 12.30%
js
NUMBERFORMAT(0.123, "0.0%")Result: 12.3%
js
NUMBERFORMAT(0.123, "0%")Result: 12%