Cell input control

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
 
R

Ron Coderre

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
 
P

Peo Sjoblom

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
 
Top