Please see the following attachment:
Why.xlsx
I have summed the column =SUM(B2:B66) and it equals 0.00. This is inaccurate. The column is full of numbers that are formatted as "number" and there is no circular looping in the formula. The SUM formula is in entered into cell B67. I've read online and everyone says it is because the numbers are formatted as TEXT, but this is not true. The numbers are not formatted as text. They are formatted as number. If I change the whole column to currency, it still remains at 0.00.
What do I do?
Bookmarks