Maybe you can apply Data|filter|autofilter
and do a custom filter of:
begins with ??0

If they values are really numbers, you could use a helper column to convert
those values to text:

=a2&""
then use that same filtering technique.

Gee wrote:

I have a db with 3000 records. Each record has a unique number that means
something. I want to return all the records that have 0 as the third digit
eg., **0****. What formula do I need to enter to do this?

Thanks,
G

--

Dave Peterson