Maximum Characters

[Stephen]

Hi All,

How can I lock a cell to a maximum number of 30 characters? I
sometimes happens that other users fill in a long sentence in a colum
called "discription". Does anybody know how I can go about it withou
using VBA.

Thanks.

Stephe

 

[Bernard Liengme]

You could change the name of the column to "description"
Sorry!

 

[Norman Harker]

Hi Stephen!

Use:

Data > Validation
Select Text Length from the drop down