Forum Discussion
Solved
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!
R0bperry904 Can anyone send me a sample of any sheet so that I can try for fix and talk about the solution
select number range or cell
right mousekey
Select "Format Cells...".
Set number to "Number", set decimal places as desired.
OK done
right mousekey
Select "Format Cells...".
Set number to "Number", set decimal places as desired.
OK done