|
|
#1
10-21-2010, 09:53 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| page length | mzimpfer | Word | 2 | 10-23-2010 11:53 AM |
| How do I get rid of this type of symbol | jerry1234 | Word | 1 | 09-04-2010 05:39 PM |
| How to set the same length for different lines | myword29 | Word | 0 | 09-28-2007 08:12 PM |
| Range names and length stuff. Please help-a-noob. | contiw | Excel | 2 | 09-06-2007 07:59 AM |
| Trouble With Data Validation And Filtering On A Dropdown | zura04 | Excel | 0 | 10-24-2006 12:54 PM |
Validation for length and numeric type
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode