FORMAT_NUMBER

Returns a string representing the number, formatted according to the given pattern.

Syntax

=FORMAT_NUMBER(value, pattern)

Argument	Type	Description
value	Number	The value to format
pattern	String	The pattern to format by

=FORMAT_NUMBER(123.456, ".?")→"123.5"

=FORMAT_NUMBER(123.456, "$ 0")→$123

=FORMAT_NUMBER(123.456, "0.00e+00")→1.23e+2

Updated 10 months ago