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

A

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

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
 
K

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.
 
Top