| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation - custom (must have "/")
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation - custom (must have "/")
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) "Johan" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Data Validation : Lock if MyCell = ""? | Excel Worksheet Functions | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Data Validation with "VBA Refreshing" out of order | Excel Discussion (Misc queries) | |||
| How can "data validation" be enforced in calculated cells | Excel Worksheet Functions | |||
| How do I get rid of "Top 10" and "Custom" choices Autofilter? | Excel Worksheet Functions | |||
![Johan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
