View Single Post
  #2  
Old April 23rd, 2010, 03:27 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Despite formula I use (for example SUM) result is always zero.

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