use a custom formula for your data validation and then put in a formula that
represents your criteria.

--
Regards,
Tom Ogilvy


"Student" wrote:

i am setting the field length to 10 digits there and couldn't add two data
validation rules at once. could I ? if yes then how?

thank you

"Tom Ogilvy" wrote:

Use the options under data validation (assume that is what you are using).

--
Regards,
Tom Ogilvy


"Student" wrote:

Good Morning!

I am trying to hard code an error message for invalid data format entered to
a formatted field.

I have selected cells B11 through B30 and set is to positive number with
zero decimal. Now I want to hard code an error message when a text is entered
in these fields.

Is there a way to do this? Please advice
Your afford is greatly appreciated