AutoFilter

S

Sheri

Thanks for the help. I am using Excel XP. I have a list of
items that come from an Oracle Database. They are vehicle
numbers that begin with a 0. (028,034,039,056, etc) I
have an autofilter and want to filter out numbers >= 028
and <= 039. I always get an empty set returned to me. I
assume this is because these are text items rather than
numbers. Is there a way to accomplish this filter with
text?
 
G

Guest

Hmmm, not really sure if this is what you mean but have
you tried puting a ' infront of the number, it denotes it
as text. (It is under the " key)
 
S

Sheri

No. That's the problem, these are text items and they
won't filter the way I need them to.
 
Top