| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation
If there's a short list of options, type it in the Data Validation
dialog box, instead of referring to a range on the worksheet. Using a delimited list will make the data validation case sensitive. Aaron wrote: I have several columns of cells that I have data validation on so people do not input data incorrectly. However the data validation still allows people to input nj when I want it to be NJ (caps). Is there anyway to force data validation to recognize caps vs. lowercase. Thanks in advance. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Hybrid Mode
