| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Numbers and Text
I am looking for a way to validate cells so that they only accept
numbers(decimal) <-- easy part and 3 text choices ("IS", "ND","MS") not so easy :) IS-insufficient sample, ND-non detected and MS-missing samples. any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Validation Numbers and Text
One way:
Allow: Custom Formula: =OR(ISNUMBER(H1),H1="ID",H1="ND",H1="MS") In article .com, "DWW" wrote: I am looking for a way to validate cells so that they only accept numbers(decimal) <-- easy part and 3 text choices ("IS", "ND","MS") not so easy :) IS-insufficient sample, ND-non detected and MS-missing samples. any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Validation Numbers and Text
Thanks so much, that is exactly what I needed, it works great.
cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Allow numbers, comma, - and space | Excel Discussion (Misc queries) | |||
| Custom Data Validation for specific text and numbers only | Excel Discussion (Misc queries) | |||
| How can I show text and numbers in data validation? i.e. L1234 | Excel Discussion (Misc queries) | |||
| Data Validation using whole numbers from formulas | Excel Discussion (Misc queries) | |||
| Unique numbers from data validation list | Excel Worksheet Functions | |||
Linear Mode
