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.

One way:

Allow: Custom
Formula: =OR(ISNUMBER(H1),H1="ID",H1="ND",H1="MS")



In article <[email protected]>,
"DWW" <[email protected]> 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.

Thanks so much, that is exactly what I needed, it works great.

cheers