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 |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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