Forum Discussion
Impossible to sum numbers in Excel
I hope someone can help with this because I am pulling my hair out. When I try to sum numbers in a column, at the bottom of the page it gives me a count and not a sum. When I try to Autosum, it g...
If your numbers are formatted as Text, changing the formula of existing numbers as General or Number won't change them back to real numbers.
To easily convert numbers entered as Text back to the real numbers, select the numbers and follow these steps...
1) Go to Data Tab.
2) Click on Text to Columns and click on Finish in the next window which pops up which is Text to Columns wizard window.
As a result, your numbers as Text will be converted into the real numbers and your existing Sum formula will return the correct output.
That worked for me, thank you!
