In C1, there is this formula "=A1+A9+A17+A25....." and the cell displays a big zero. I can see that A1 is 3240. So is A9, A17, A25, etc. In D1, I enter this formula "=A1" and the result is another zero. If I copy A1 and paste to E1, the result is 3240. If I enter "=E1" in F1, the result is 0.
summary: Copy A1 to E1, result: 3240; enter "=E1" in F1, result: 0, enter in D1 "=A1", result: 0;A1 is 3240.
This is not number formatting problem. I cleared all formats and got the same result. If I set the cells to display one decimal, I got 0.0 and 3240.0.
What's going on?
summary: Copy A1 to E1, result: 3240; enter "=E1" in F1, result: 0, enter in D1 "=A1", result: 0;A1 is 3240.
This is not number formatting problem. I cleared all formats and got the same result. If I set the cells to display one decimal, I got 0.0 and 3240.0.
What's going on?
Last edited: