View Single Post
  #4  
Old April 26th, 2010, 09:43 AM posted to microsoft.public.excel.worksheet.functions
Anida
external usenet poster
 
Posts: 2
Default Despite formula I use (for example SUM) result is always zero.

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??



.