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

J

Jim

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.
 
J

JulieD

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
 
Top