I have a large workbook with several similar versions of data. On the most
current sheet I cannot filter a column of numbers with the custom and <
criteria. When I try to filter this way, it takes me one row past the end of
the data and does not display any of the existing data. I have already
confirmed that these are formatted as numbers and not text.

The older (similar) worksheets in the same file will functiion correctly
with the exact same filter criteria.

Just because the cells are formatted as number, doesn't mean the value in the
cells are numbers.

You can convert Text Numbers to Number Numbers by:
select an empty cell
edit|copy
select the range to fix
edit|Paste special|add

Then try your filter once more.



dsmm wrote:

I have a large workbook with several similar versions of data. On the most
current sheet I cannot filter a column of numbers with the custom and <
criteria. When I try to filter this way, it takes me one row past the end of
the data and does not display any of the existing data. I have already
confirmed that these are formatted as numbers and not text.

The older (similar) worksheets in the same file will functiion correctly
with the exact same filter criteria.

--

Dave Peterson