So just use a helper column. In cell E2 put this and copy down:

=MID(TEXT(A2,"00000000"),2,1)="0"

Now pop in a header and filter on TRUE or FALSE depending on what you want.

Your problem stems from the fact that your data is set to display the number
616946 as 00616946, so what you see isn't actually what you have, so you
will find it hard to filter on those 0s when they don't exist.

The TEXT function will simply ensure that what you actually see is returned
as a value, and then the MID function simply allows you to focus on that
second character. Note it is now TEXT so hence the quotes round the 0.

Regards
Ken........................



"apandbp" wrote in message
...

This one has me truly beat. I have a long list of numbers, and I need
to filter the ones out that have a zero as the second digit from the
left. I have been using auto filtercustom and tried using wild cards,
and have had no success. I have included some sample data below. You
can also find a copy of the actual xls sheet at
www.ideaharvesters.com/testxls.xls

Account
00616946
03745254
03745254
10043826
13635685
20071601
20560611
20560611
20560611
23474810
30437875


--
apandbp
------------------------------------------------------------------------
apandbp's Profile: http://www.thecodecage.com/forumz/member.php?userid=550
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=118775