Count formula doesn't work

[Guest]

Hi people
I am trying to do a counting on how many cells contain a number in a column. So I use the formula =count(A:A). I tried it on a spreadsheet which contains 10300 data in the column and it works. Then I tried it on another spread sheet which contains 50000 data in the column and it gives me a zero
I don't understand why it does that
Could someone please help me out

Thank you in advance

 

[Guest]

Mr. Hawly
How do you format a column as any number format?

I also try the other way. However, because my column has many blank cells
e.g
Mill
----
55




Mill
----
55
So after edit special mutiply, my column becomes

Mill
----
55
0
0
0
0
0
Mill
----
55
So is there a way to select the text/number but not the blank cells?

 

[Guest]

Hey guys I got it
I select the whole column and go to Edit->Go to->special->constant and it select all the data(with no blank cells)
Thank you guys for showing me how to change "text" number to "real number"
very appreciated

 

[RichardS]

Just checking my password is all