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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation 4
limit number of characters in cell 4
How to limit the number of characters in a cell? 5
I need to have a certain number of characters in a cell 8
Fixed Length, Text Formatted 2
Column Widths, Importing ANSI txt files 1
Cell with same number of characters 2
Forcing Second Line in Excel 2

Back
Top