Look, up in the sky, it's a bird, it's a plane, it's E1man! (or E1woman :)
--
** John C **

"Gary''s Student" wrote:

=OR(AND((LEN(A1)=6),ISNUMBER(A1)),(E1="Z"))

So even if A1 is not quite good enough, E1 can save the day!

--
Gary''s Student - gsnu200809