Thread: cell that only a certain number may be entered
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default cell that only a certain number may be entered
Use Data Validation.
--
Gary''s Student


"jbailey" wrote:

I need a cell to allow only a certain number to be entered such as a 2 or a 0.
Reply With QuoteReply With Quote