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 <1118074040.189466.204390@z14g2000cwz.googlegroups.com>,
"DWW" <shawn@digitalwebworks.ca> 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