Many thanks Ron

Luckily I am just using the formula in a cell!

Regards
Kenny W

"Ron Rosenfeld" wrote in message
...
On Thu, 23 Oct 2008 04:14:01 -0700, Mike H

wrote:

No,

You could have done this

=IF(AND(LEN(A1)=5,NOT(ISERROR(FIND({"1","2","3", "4","5"},A1)))),TRUE,FALSE)

Mike

That's OK for just a formula in a cell, but you can't use an array
constant in
a Data Validation custom formula.
--ron