Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change from lowercase to uppercase
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change from lowercase to uppercase
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")) -- Regards, Tom Ogilvy "Henry" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change uppercase to lowercase without re-typing (Excel) | Excel Discussion (Misc queries) | |||
In excel , is there a way i can change UPPERCASE to lowercase? | Excel Discussion (Misc queries) | |||
uppercase to lowercase | Excel Discussion (Misc queries) | |||
In Excel, can you change uppercase letters to lowercase | New Users to Excel | |||
How do I do a global change from uppercase to lowercase? | Excel Discussion (Misc queries) |