View Single Post
 
Old 10-21-2010, 09:53 PM
chamsy chamsy is offline Windows 7 Office 2010 (Version 14.0)
Novice
 
Join Date: Oct 2010
Posts: 1
chamsy is on a distinguished road
Default 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.
Reply With Quote