#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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) |
|
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 |