When i try to filter information, excel returns a blank page?

[AJoudrie]

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

[Duke Carey]

Your numbers are probably in as text. Try copying an empty cell, then
selecting all the numbers and using Edit>Paste Special>Add>Values to convert
them to numbers, then see if your filter works


"AJoudrie" wrote:

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

[Kevin Vaughn]

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 Vaughn


"AJoudrie" wrote:

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