Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

Similarly, if it is a Number Stored as Text error, you can choose Convert to Number to change the text-formatted number into a proper numeric value or choose Edit in Formula Bar to manually remove ...