View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Data Validation Question?

Data/ Validation/ Allow: List, and in source include: 1, E, e, A
--
David Biddulph

"mastermind" wrote in message
ps.com...
I need to limit the data entered into a cell to be either: 1, E, e, A,
or a. Can someone tell me the custom formula I would need, to achieve
this result? Thank you.