|
|
#2
10-22-2010, 07:31 AM
|
|||
|
|||
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) 
|
| Thread Tools | |
| Display Modes | |
|
|
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