| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why can't I enter a valid number in a cell with data validation
Turn off the error alert for those cells and make sure "ignore blanks" is
checked. Gord Dibben MS Excel MVP On Tue, 29 May 2007 11:16:01 -0700, wildes06241 wrote: I have a worksheet with several columns that have data validation set on them. In some I am allowed to type the data as long as it is in the validation list. In others I can not manually enter the numbers I must select from a pull down menu. Please help. It's driving me crazy because it takes much longer to select from a long list than it does to enter the 2 digit number manually. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is * valid if Excel data validation list has no blanks or *? | Excel Worksheet Functions | |||
| Custom Validation Not Accepting Valid Data Revision | Excel Worksheet Functions | |||
| How do i set up data validation to only enter yes or no? | Excel Worksheet Functions | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| excel validation, enter particular score in only one cell of a ran | Excel Worksheet Functions | |||
Threaded Mode
