This quick fix might suffice for you
Instead of using: =SUM(A2:A5)
use this, array-enter it, ie press CTRL+SHIFT+ENTER to confirm the formula:
=SUM(A2:A5+0)
The "+0" will coerce all text numbers (if any) within the source range
(A2:A5) to real numbers w/o impacting their intrinsic values, and return the
desired results. Happy? hit the YES below
--
Max
Singapore
---
"Anida" wrote:
Despite formula I use (for example the most simple SUM) it always shows me
zero result even it should show a lot more. Values in other cells (cells that
I sum) are in number format. Why this happens??