COUNT() returns incorrect value

[Bill Mathews]

I have a spreadsheet in Excel 97 in which I wanted to use the COUNT()
function to count the number of entries. The values in the column that is to
be counted are all numeric. To be sure of that, I selected _all_ the values
in the column and set the format to 'number, 0 decimal places, right and top
alignment'.

The COUNT() function returns an incorrect value, one too low. If I change
COUNT() to COUNTA(), the correct value is returned.

Any ideas why COUNT() isn't counting the number of numeric values correctly?

(Please don't tell me that it's because some of the values in the column are
still in text - as I said, I set _all_ the the values to number format.)

Thanks,
Bill

 

[Paul B]

Bill, I know you did not want me to tell you this but I think you still may
have a number as text, if the number was entered with the cell formatted as
text just changing the formatting will not change it back to a number, to
check them put =ISNUMBER(A1),where a1 is the cell you want to check and see
if all of them are true, if one says false it is not a number to excel

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **