Thread: Restrict data entry in a cell
View Single Post
  #2  
Old March 18th, 2010, 08:30 PM posted to microsoft.public.excel.worksheet.functions
Bob Umlas[_3_]
external usenet poster
  
Posts: 197
Default Restrict data entry in a cell
Data/Validation
select List
enter:
1,2,3,4,5,6,7,10
Click OK.
You're done.
Bob Umlas
Excel MVP

"Ephraim" wrote in message
...
Hi,
I would like to ensure that a user can only input one of the following
numbers in a cell:
1, 2, 3, 4, 5, 6, 7 or 10

I'm using Excel 2003.

Thank you
Ephraim