Validation ... Case Sensitive?

G

Guest

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
 
B

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)
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color of Validation Circles? 1
Validation for state abbreviations 2
Validation vs Case 3
Data Validation 2
Capital Letters Only 2
Data validation on data validation function 1
data - validation - list question 2
Formatting cells to only upper case 5

Top