change from lowercase to uppercase

G

Guest

Hello,

I made a validation to limit the user could input "O" and "X" only. However,
when the user hardcoded in lowercase, excel state that's an error. How can i
force the lowercase input to become uppercase? coz i would only see uppercase
on the cell.

Thanks,
 
G

Guest

Try using the Exact function in your validation

for cell D4, I selected custom in validation and used this formula
=OR(EXACT($D$4,"X"),EXACT($D$4,"O"))
 

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

Change cell range to Uppercase 1
COMBO BOX vs Uppercase 6
Excel - stop automatically changing mixture of uppercase and lowercase to propercase 2
Changing uppercase to lowercase 4
How can I convert the contents of a text selection from uppercase. 1
Change a range to Uppercase 3
Change Text to Uppercase Excel 2003 2
Changing from lower case to upper case 11

Top