Forum Discussion
Excel continues to have SUM 0.00 even though all formula are correct
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!
One thought would be that maybe the € or $ sign is entered instead of assigning it through the format.
In addition, there may be unprintable characters in the cells.
This would mean that all values would be text and so they could not be calculated with them.
Nikolino
I know that I don't know (Socrates)
do =NUMBERVALUE(A2)