Yes I understand and I do use it but perhaps I was not clear enough. see my
response post to Niek Otten.
Luke

"vezerid" wrote:

> Luke,
> I am not really sure what you are looking for here, but the one thing
> that is certainly not going to work in your formulas is comparison of
> text and numbers. Use VALUE(RIGHT(...))<=whatever if you want to
> compare the numeric value of a portion of text with another cell that
> has numeric content.
>
> HTH
> Kostis Vezerides
>
>