Cell input control

  • Thread starter Thread starter Bobby Baccala'
  • Start date Start date
B

Bobby Baccala'

Hi,

in Excel 2003, is there a way to set a cell, or a column, in a way
that a user can only enter a limited number of character in it?

For instance, I want a user cannot enter more than 10 character into
any cell of column C.

thanks for help
 
Try Data Validation:

Select the cells to be impacted

From the Excel main menu:
<data><validation>
Allow: Text Length
Data: Less than or equal to
Maximum: 10
Click [OK]

Note:
You can use the Input Message tab to give the users instructions
and
you can use the Error Alert tab to set whether the users are forced to
comply or only warned.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Select the range you want this, then do data>validation, under allow select
text length and select between 0 and 10 characters

Note that it won't prevent people from pasting values that differ from this,
just typing
 
Back
Top