Hi Sara

Try
DataValidationAllowText lengthless than or equal your_number

--
Regards

Roger Govier


"Sara Stone" wrote in message
...
Hello,

Is there a way to limit the number of characters that can be entered
into a
cell without created a text box and doing it that way?

Thanks.