Setting Data Validation
 

Can anyone tell me how, if possible, can I set up a data validation, such the
entry must star with a capital E and be followed by 3 numeric digits?

Thanks
Bill

Setting Data Validation
 

I'm sure it can be done more elegantly but with A1 selected select Custom
from the Data Validation Allow drop down and paste this in:

=EXACT(LEFT(A1,1),"E")*(LEN(A1)=4)*NOT(ISERROR(RIG HT(A1,3)*2))

--
Jim
"Techtrainer" wrote in message
...
| Can anyone tell me how, if possible, can I set up a data validation, such
the
| entry must star with a capital E and be followed by 3 numeric digits?
|
| Thanks
| Bill

Setting Data Validation
 

Thanks!! Worked great!!

"Jim Rech" wrote:

I'm sure it can be done more elegantly but with A1 selected select Custom
from the Data Validation Allow drop down and paste this in:

=EXACT(LEFT(A1,1),"E")*(LEN(A1)=4)*NOT(ISERROR(RIG HT(A1,3)*2))

--
Jim
"Techtrainer" wrote in message
...
| Can anyone tell me how, if possible, can I set up a data validation, such
the
| entry must star with a capital E and be followed by 3 numeric digits?
|
| Thanks
| Bill