autofilter problem
 

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

autofilter problem
 

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


On 17 Nov 2006 13:22:39 -0800, "Tonso" wrote:

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

autofilter problem
 

Hi

Could you try Greater than 89999

--
Regards

Roger Govier


"Tonso" wrote in message
oups.com...
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

autofilter problem
 

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


Tonso

Roger Govier wrote:
Hi

Could you try Greater than 89999

--
Regards

Roger Govier


"Tonso" wrote in message
oups.com...
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

I thought Roger's answer was more logical, actually, FWIW.

autofilter problem
 

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

On Sat, 18 Nov 2006 23:16:34 +0000, BizMark
wrote:


I thought Roger's answer was more logical, actually, FWIW.

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


Tonso

Roger Govier wrote:-
Hi

Could you try Greater than 89999

--
Regards

Roger Govier


"Tonso" wrote in message
oups.com...-
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
--

autofilter problem
 

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

On Sat, 18 Nov 2006 23:16:34 +0000, BizMark
wrote:


I thought Roger's answer was more logical, actually, FWIW.

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


Tonso

Roger Govier wrote:-
Hi

Could you try Greater than 89999

--
Regards

Roger Govier


"Tonso" wrote in message
oups.com...-
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 MS Excel MVP

autofilter problem
 

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.


--
Regards

Roger Govier


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Sat, 18 Nov 2006 23:16:34 +0000, BizMark
wrote:


I thought Roger's answer was more logical, actually, FWIW.

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


Tonso

Roger Govier wrote:-
Hi

Could you try Greater than 89999

--
Regards

Roger Govier


"Tonso" wrote in message
oups.com...-
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 MS Excel MVP

autofilter problem
 

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

On Sun, 19 Nov 2006 11:47:20 -0000, "Roger Govier"
wrote:

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 MS Excel MVP