View Single Post
 
Old 10-22-2010, 07:31 AM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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)
Reply With Quote