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
|