Validation for length and numeric type
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.
|