| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is * valid if Excel data validation list has no blanks or *?
In Excel 2007 (Windows XP Pro), I created a dropdown list (on another
worksheet in the same file) of valid characters with which names can be created. The list includes all the characters on the standard keyboard, except for spaces and * \ ? < : ' " | I have left the "ignore blanks" unchecked. The system successfully prevents all of the forbidden characters from being used, except for the *. The only way I can keep the * from being allowed is to completely depopulate the list of allowed characters. Why? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation list with blanks at the bottom | Excel Discussion (Misc queries) | |||
| Custom Validation Not Accepting Valid Data Revision | Excel Worksheet Functions | |||
| blanks in data validation list dropdown | Excel Worksheet Functions | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| validation list blanks | Excel Worksheet Functions | |||
Threaded Mode
