Count formula doesn't work

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?

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