fixed width

N

Need Help

Is there a way to set the cell up to 30 characters
length? E.g. when 30 characters were typed, the cell will
not accept anymore input.
 
P

Peo Sjoblom

One possible way

data>validation>allow text length, less than or equal, put 30 in the maximum
box
 
K

Ken Wright

Note though that you will need to put some kind of error message in there to tell people
it should only be 30 characters (There is an option for this), as it will allow you to
type as many letters as you want, but will error out when you try to enter it.
Unfortunately it will not simply stop at 30 and just enter that for you.
 
Top