Excel automatically updating workbooks
And how do I get my Excel to calculate and update formulas automatically again?
Don't worry, most likely your Excel is all right, and you will get all the answers in a moment.
copy your text-numbers to Notepad, and then back to a new column), and delete the broken column.
Another possible solution is to multiply the values in the problematic column by 1 using a simple formula like .
Numbers formatted as text values are another common reason for Excel formulas not working.If your formula is short of one or more parentheses, Excel displays an error message and suggests a correction to balance the pairs.