Validation ... Case Sensitive?

[Ken]

Excel 2003 ... I have a Data Validation List (& Switch) that is working fine
(ALL UPPER Case in the List & Switch) ... However, entries can still be made
from the keyboard ... Some folks are entering LOWER Case which Validation is
accepting ...

Above said ... I wish to set Data Validation to accept only UPPER Case.

Can I do this? ... Thanks ... Kha

 

[Bob Phillips]

Try adding a formula in the DV allow type of custom of

=EXACT(K1,UPPER(K1))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Debra Dalgleish]

If the list is short, you could type upper case entries in the Data
Validation dialog Source box. That would validate for upper case entries
in the cell.

If the list is a range on the worksheet, the data validation isn't case
sensitive. You could use programming to convert entries to upper case
after they're typed.