On Sun, 2 Sep 2007 20:40:57 -0400, "Ron Coderre"
wrote:

Just use a wildcard to make Excel treat the criteria as text...

Try this
=COUNTIF(A1:A10,"010020*")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)


Learn something new every day here.
--ron