View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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