Despite formula I use (for example SUM) result is always zero.
Make sure that calculation is set to automatic.
In xl2003 menus:
tools|options|calculation tab
And your range to sum does include A2, right?
Anida wrote:
When I put =isnumber(a2) it shows me true, and for =istext false. What next?
"David Biddulph" wrote:
It doesn't matter whether the cells are FORMATTED to DISPLAY as number;
what matters is whether the CONTENTS are numbers. My guess is that they are
text that might look like a number. If one of your numbers is in A2, what
do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show?
--
David Biddulph
"Anida" wrote in message
...
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??
.
--
Dave Peterson
|