Limiting text
 

How do I limit the number of characters that can be entered into a cell?

Thanks

Limiting text
 

Hi
'Data - Vaidation' and specify your max number of characters

--
Regards
Frank Kabel
Frankfurt, Germany

"Sheldon" schrieb im Newsbeitrag
...
How do I limit the number of characters that can be entered into a
cell?

Thanks

Limiting text
 

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