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!
I'm have the same issue with a new install of Excel - I'm trying to figure out a better way to correct the issue also. I found 3 items in a list of about 25 items that were not adding in. I highlighted all numbers and formatted for numbers but it still didn't work.
I found a way to correct it, but isn't ideal - I went to an open area on the spreadsheet and formatted for a number before typing in the same number, then copied and pasted it back - it worked. So, I'm thinking that it needs to be formatted for a number before you add any numbers. It appears that text is the common format (I'm trying to find out how to change that), so changing it to number after it's entered, doesn't fix the problem. Hope that helps and I didn't confuse you too much!
Yes ... when trying to add a column of figures including a SUM from higher up the column I had the same problem. I removed both the SUM functions, reformatted the column once again as currency, readded the SUM function for the sub total then readded the SUM function at the bottom of the column. The SUM now adds a column of figures plus an existing SUM higher up the column. Thanks for the tip.
Barb1010 Thank you so much for your post. This is exactly what my problem was. Bless you!!!
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!
