filter works on letters not numbers

C

Churley

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.
 
T

toni.gee

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".
 
C

Churley

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

Top