What is the most common symptom of numbers stored as text?
- A SUM returns zero or ignores those cells
- B The cells display in red
- C Excel crashes
- D The file size increases
Answer
SUM returns zero or ignores those cells
A small green triangle usually flags it. Text to Columns with no delimiter, or the VALUE function, converts them.





