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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function or Sub to help with text string 5
Formatting question: how to format duration (time spent)? 0
VLOOKUP & Data Validation 0
Newbie Help - IF Yes No Function 0
Data Validation - Complex Q 2
IF validation for time totaling 2
Formating bolded text exclusively. 0
Advanced text function (combining text) 2

Top