autofilter problem

[Tonso]

i am using xl 2002 for windows. my autofilter works fine for selecting
a certain catagory, say 99235
or 348851. but if i try to use a Custom filter, specifically "Begins
with" then type in 99, it shows nothing. i have tried to use text
format, general format, and number format, with the same result....all
the rows with data are hidden. what am i overlooking?

thanks

billy

 

[Gord Dibben]

Tonso

Quote from a Dave Peterson posting............

Real numbers won't work the way you want.

But if you add a helper column and convert that number number to a text number,
you could filter on that helper column.

You could use:

=text(a2,"0000.000")
or
=a2&""

to convert to text (depending on what you want to see)

End Dave quote.......................................


Gord Dibben MS Excel MVP

 

[Roger Govier]

Hi

Could you try Greater than 89999

 

[Tonso]

Gord, David...that works fine! Thanks to all who replied!


Tonso

 

[Gord Dibben]

Curious

If you are looking for numbers beginning with 99 why is Greater than 89999
logical?

That would return all numbers greater than 89999 and miss out numbers like 9902
or 999

To give Roger a break, maybe he meant greater than 98999 and less than 100000
which would return any number from 99000 to 99999

I am assuming 89999 was a typo.


Gord

 

[Gord Dibben]

Only if the numbers are 5 digit that is

To give Roger a break, maybe he meant greater than 98999 and less than 100000
which would return any number from 99000 to 99999

Gord



Curious

If you are looking for numbers beginning with 99 why is Greater than 89999
logical?

That would return all numbers greater than 89999 and miss out numbers like 9902
or 999

To give Roger a break, maybe he meant greater than 98999 and less than 100000
which would return any number from 99000 to 99999

I am assuming 89999 was a typo.


Gord

Gord Dibben MS Excel MVP

 

[Roger Govier]

To give Roger a break
Thanks Gord, I needed the break<bg>

Yes I had meant 98999 and had rather focussed on the OP saying they had
said begins with "99".
I totally omitted to say an upper limit or that it only applied to 5
digit answers.

A hasty and poorly thought out response on my part I am sorry to say.

 

[Gord Dibben]

And a rather hasty first posting by myself.

Pointing out that to use "begins with" on numbers is not possible but neglecting
to give OP an alternative to use the custom >98999 and <100000as you did(typo
notwithstanding)


Gord

Thanks Gord, I needed the break<bg>

Yes I had meant 98999 and had rather focussed on the OP saying they had
said begins with "99".
I totally omitted to say an upper limit or that it only applied to 5
digit answers.

A hasty and poorly thought out response on my part I am sorry to say.

Gord Dibben MS Excel MVP