Data validation - custom (must have "/")

J

Johan

I want only to allow text entered with a "/" character in the middle
of the cell. From 0/0 to 99/999 how do I do this?
 
B

Bob Phillips

Use a custom type of

=AND(ISNUMBER(FIND("/",H1)),ISNUMBER(--SUBSTITUTE(H1,"/","")))

--
HTH

Bob

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