Thread: Filtering
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Filtering

Your zip codes may be stored as text values, though they look like
numbers. You could add a new column and convert the values to numbers
then filter on this new column, or if you want to retain the codes you
have then in the custom filter pull-down you could try "begins with" -
doesn't always work with numbers, though.

Hope this helps.

Pete