Possible to validate entries not to contain 00

[mralmackay]

Hi,

I need to be able to validate entries within a data range (H2:H1000).
Within these cells I need to be able to put a limit that they must
only have:
1) Four characters (Numeric if poss' to force by type as well)
2) End two characters must not contain 00.
3) Or they can be Null

Is this poss' through data validation, or would this need to be done
via VBA (trying to avoid VBA option if poss').

Cheers, Al.

 

[Bob Phillips]

Use DV with a formula of

=OR(H2="",AND(LEN(H2)=4,ISNUMBER(H2),RIGHT(H2,2)<>"00"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)