Thread: cell that only a certain number may be entered
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jbailey jbailey is offline
external usenet poster
  
Posts: 4
Default cell that only a certain number may be entered
I tried that but it still accepts a different number such as 1

"Gary''s Student" wrote:

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