J Johan Mar 31, 2008 #1 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?
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 Mar 31, 2008 #2 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)
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)
