View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Churley Churley is offline
external usenet poster
 
Posts: 28
Default filter works on letters not numbers

I have a spreadsheet from a query with various columns of numbers and letters.
If I do a custom filter on the column with letters, and, say,"does not
equal" a certain letter, the filter will work. If I do a custom filter on any
column with numbers, the same filter will not work. All cells are formatted
"general". I have tried formatting the numbers as "number", but that doesn't
work either.
Any thoughts will be appreciated.

Thank you.