Custom filter won't return charcters between 1-9 inclusive

W

William

I have an alphanumeric column for which I am attempting to filter for all
numeric between 1-9. If I try "greater than or equal to 1" AND "less than or
equal to 9" I get NO rows, even though there are values from 1-9. Even
trying just "less than or equal to 9" returns no rows.

What am I missing here?
 
P

Peo Sjoblom

Your numbers are probably seen as text, make sure there is no alignment in
the cells, the default for text is left aligned so if your numbers are left
aligned they are text, did you import them (that is a often a problem with
numbers seen as text)?

You can try to convert them to text, make sure the format in the cells are
general, then select the range with numbers and do data>text to columns,
then click finish, now try it


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
 
Top