fixed width

  • Thread starter Thread starter Need Help
  • Start date Start date
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.
 
One possible way

data>validation>allow text length, less than or equal, put 30 in the maximum
box
 
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.
 
Back
Top