software

I am in Excel and I am trying to filter information. I have a column that
has all numbers init, and I cam trying to do a filter with all the numbers
that are lt;100. When I do this custom filter, excel brings up nothing, just a
blank page, but there is numbers less than 100, but they will not show up.
This spreadsheert was imported from Navision. I have tried it with other
columns and it works, just not with this one column.

Any ideas as to why this might be happening????

Your numbers are probably in as text. Try copying an empty cell, then
selecting all the numbers and using Editgt;Paste Specialgt;Addgt;Values to convert
them to numbers, then see if your filter worksquot;AJoudriequot; wrote:

gt; I am in Excel and I am trying to filter information. I have a column that
gt; has all numbers init, and I cam trying to do a filter with all the numbers
gt; that are lt;100. When I do this custom filter, excel brings up nothing, just a
gt; blank page, but there is numbers less than 100, but they will not show up.
gt; This spreadsheert was imported from Navision. I have tried it with other
gt; columns and it works, just not with this one column.
gt;
gt; Any ideas as to why this might be happening????

It sounds like maybe those numbers aren't numbers after all. They may be
formatted as text. If so, try copying a blank zero (blank has a value of 0)
and then do a paste-special to your non-numeric numbers range and choose the
Add operation. Basically, you are adding 0 to the range and Excel should now
recognize those numbers as numbers.

--
Kevin Vaughnquot;AJoudriequot; wrote:

gt; I am in Excel and I am trying to filter information. I have a column that
gt; has all numbers init, and I cam trying to do a filter with all the numbers
gt; that are lt;100. When I do this custom filter, excel brings up nothing, just a
gt; blank page, but there is numbers less than 100, but they will not show up.
gt; This spreadsheert was imported from Navision. I have tried it with other
gt; columns and it works, just not with this one column.
gt;
gt; Any ideas as to why this might be happening????