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