View Single Post
  #5  
Old April 26th, 2010, 12:26 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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