Maybe Data Validation ?
Select the cell
Click Data Validation
Make the settings:
Allow: Text length
Data: less than
Maximum: 5 (say)
Click OK
Now test it out by entering into the cell
say, a text phrase 4 characters
(You should get the error message)
--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"Sheldon" wrote in message
...
How do I limit the number of characters that can be entered into a cell?
Thanks