Validation

  • Thread starter Thread starter B_cooper123
  • Start date Start date
B

B_cooper123

I'm looking to have a validation rule which shows up an error message when
text that isn't entered into the correct location happens.

I.E i've got a bar where a 5 digit Number is to be entered, so if say a 4
digit number was entered, a message would flag up saying - Please Enter a 5
Digit number ??

Can anyone help
 
In Data Validation dialog choose.....
Allow: Text length
Data: between
Minimum: 5
Maximum: 5 (unless you want 5 or more - then enter a number suitable to your
requirements)

Rob
 
And....
If you need to know how to set a message to appear other than the default,
then do this....
Again, in the data validation dialog,
select the Error Alert tab
Make sure "Show error alert after invalid data is entered" is ticked.
Style: Stop
Title: Enter whatever you like.....maybe "Error!" without the quotes
Error Message: "Please Enter a 5 Digit number " without the quotes

Rob
 
Data Validation/ Settings/ Custom/ Formula:
=AND(ISNUMBER(A1),LEN(A1)=5)

Set input message and error message as appropriate.
 
Back
Top