Problem with Data Validation and limiting characters
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?
|