These docs are for v1.0. Click to read the latest docs for v1.2.

FORMAT_NUMBER

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

Syntax

=FORMAT_NUMBER(value, pattern)

Arguments

ArgumentTypeDescription
valueNumberThe value to format
patternStringThe pattern to format by

Examples

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

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

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