Hi,

I want to add a data validation for excel cell.
I need to check these conditions.
1. Length should be 3 characters.


2. All three characters should be numeric digits.
ex. It can be 011,112 or 450

I can do the first validation. But plz help me to do the second validation with first one.

Thanks.

Format the range as Text. If the range isn't formatted as text, it won't work properly.

In the Data Validation dialog box, choose Custom and use this forumla. It covers both conditions (text length and numeric digits only).

Replace A1 with the address of the first cell in the range.
=AND(ISNUMBER(A1*1),LEN(A1)=3)