how do i specify a maximum lenght allowed in a cell. example: A1 = 8 digits B1 = 3 characters
B Bob Aug 19, 2008 #1 how do i specify a maximum lenght allowed in a cell. example: A1 = 8 digits B1 = 3 characters
M Mike H Aug 19, 2008 #2 Bob, Data validation will do that Select A1 then Data|Validation In the 'Allow' dropdown select 'Whole number in the 'data' box select less than or equal to in the maximum box enter 99999999 Similarly for b1 Select Text Length Less than or equal to enter 3 Mike
Bob, Data validation will do that Select A1 then Data|Validation In the 'Allow' dropdown select 'Whole number in the 'data' box select less than or equal to in the maximum box enter 99999999 Similarly for b1 Select Text Length Less than or equal to enter 3 Mike
