FORMAT_NUMBER
Returns a string representing the number, formatted according to the given pattern.
Syntax
=FORMAT_NUMBER(value, pattern)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to format |
| pattern | String | The 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
Updated about 1 year ago
Did this page help you?