I need to limit the characters of one cell to a maximum of 28.

Here's what I've done:

Data Validation
Allow: Text length
Data: Less than or equal to
Maximum: 28

However this isn't working. It is still allowing any number of characters
over 28. I even tried:

Allow: Text length
Data: Between
Minimum:0
Maximum: 28

all to no avail. Any ideas?

It sounds like the Data Validation alerts are either disabled or set to
somethng other than "STOP"


From the Excel main menu:
<data<validation<error alert tab
The style setting should be: STOP

(otherwise, invalid entries will be allowed)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"MagnoliaSouth" wrote:

I need to limit the characters of one cell to a maximum of 28.

Here's what I've done:

Data Validation
Allow: Text length
Data: Less than or equal to
Maximum: 28

However this isn't working. It is still allowing any number of characters
over 28. I even tried:

Allow: Text length
Data: Between
Minimum:0
Maximum: 28

all to no avail. Any ideas?

"Ron Coderre" wrote ...
....Does that help?
***********
Regards,
Ron
Absolutely and it worked like a dream. I can't believe I couldn't figure
that one out.

Thank you so much!