Thread: Why can't I enter a valid number in a cell with data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wildes06241 wildes06241 is offline
external usenet poster
  
Posts: 3
Default Why can't I enter a valid number in a cell with data validation
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.
Reply With QuoteReply With Quote