Google spreadsheet formula not updating
The visual indicators of text-numbers are as follows: The below screenshot shows that even a simple Excel SUM formula may not work because of numbers formatted as text: To fix this, select all problematic cells, click the warning sign, and then click Convert to Number: In some cases, however, neither green triangles nor the warning sign appear in cells.
For example, if you enclose numeric values in double quotes in your formulas, Excel assumes you want to output a text string rather than a number.
And then, use exactly that character to separate arguments in your Excel formulas.
So, whenever you are writing a formula for numerical values, follow this simple rule: don't enclose numbers in double quotes unless you want them to be treated as text.
When using a number in an Excel formula, don't add any decimal separator or currency sign like $ or €.
Another possible solution is to multiply the values in the problematic column by 1 using a simple formula like .
Most of us are used to separating function arguments with commas. The character you use to separate arguments depends on the List Separator set in your Regional Settings.