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.
Bless you for your response. This has driven me crazy for a very long time. In the old days spreadsheets would let you add numbers regardless if it was text or a number (because that is the whole purpose of a spreadsheet :-D). Thank you so much for elucidating me on how to fix this ridiculous problem.
Thanks! You're welcome davidelkinsrice! Glad you found it helpful.
