Sorry I didn't see the followup message before I posted so I didn't
realize you were already using data validation. You can't combine two
built-in validation criteria, but you can combine them using
Allow=Custom.

Let us know exactly how you are setting the field length to 10 digits
using data validation and I'll try to provide more specific help.

Dave Parker


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

" wrote:

Hi
Will Data, Validation from the main Excel menu not do it?

regards
Paul
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