Formulas support whole numbers, decimals, or fractions. Commas, spaces, locale-specific, percentage, currency or scientific formats are not supported.
| Recognized as a number | Not recognized as a number |
|---|---|
0 | 0,0 |
1000 | 1,000 |
| 1 100 025 |
11.25 | 1.234e+04 |
.111 | ($100) |
You can write a number that is written with a locale-specific decimal and thousands separator as a text value, and it will be automatically converted to a number if needed. For example:
"1 122,25" * 2 → 2244.5