Custom filter will not return characters between 1-9 inclusive

[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?

 

[Peo Sjoblom]

Please avoid multi posting, one group is normally enough and if not cross
post instead since the people who answer can see it has been posted in
multiple groups

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

 

[William]

The data is imported and the numbers are left-justified. I am not quite sure
what you meant by "data>text". I sorted by this column, changed to "General"
the selected the numbers (still left-justified) and changed them from
general to "text", but the custom filter still does not function as
expected.

 

[Gord Dibben]

Simply re-formatting will not change these to numbers.

Peo suggested going to Data on the Menu and selecting Text to Columns

First select your data range then Data>Text to Columns and hit "Finish"

Should do the trick.


Gord Dibben MS Excel MVP