How do I format a cell so that only specific numbers can be enter.
 

I want to format a cell so that only specific numbers can be entered. For
instance only numbers between 1 and 5 can be entered. All other numbers will
either force an error message or simply cannot be entered.

Hi Jim

check out data / validation
(choose whole number - between 1 & 5 ... you can also write your own error
messages on the error alter tab)

check out
www.contextures.com/tiptech.html

for additional details on using Data Validation

Cheers
JulieD

"Jim" wrote in message
...
I want to format a cell so that only specific numbers can be entered. For
instance only numbers between 1 and 5 can be entered. All other numbers
will
either force an error message or simply cannot be entered.