View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ajayb ajayb is offline
external usenet poster
 
Posts: 22
Default Wildcard Advanced Filter

Hi all,

I have a column of staff numbers like so:

30002042
30002026
30002072
30002070
30002094
30002008
30002022
30002018
30002099
30002031
30002062

When I try to find all staff whose number ends in 2, my *2 wildcard criteria
is retirning no records. I have tried formatting the range to number,
general and text to no avail! Can anyone tell me what I'm missing here?

Many thanks

Andy