Forum Discussion
Excel continues to have SUM 0.00 even though all formula are correct
My =SUM continues to display 0.00 when adding multiple cells with function totals of their own. My column values each have cell D4 with formula =SUM(C4*M4) to get a total of two entered values for ...
If any of your numbers are left aligned, they are probably text - you can't just click on them and change them to numbers so...
I did a search on Excel "convert text to numbers" - pro users probably already know this but as I mentioned, I'm using a new version - if you highlight the column of numbers that aren't adding up and then go to "Data", click on "Text to columns" - click Next, click Next, click Finish - it will convert any text to numbers. Much easier than my last post!
