filter works on letters not numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
This is probably due to Excel not storing numbers as integers, whilst you are
inputting your filter criteria as an integer. Try using a combination of "is
greater than" and "is less than".
 
Thank you.
I tried changing the filter to "does not contain", and "does not begin
with", and both of these worked as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter on currency number format 3
Filter will not work --> Number Ends With 5
Creating sequential numbers plus a letter 4
does not contain letter filter 5
Showing Letters For Column Headers Rather Thann Numbers ? 1
Multiple criteria for filters 4
Filtering question 2
Excel 2003 Filtering Mistery 8

Back
Top