up vote 4 down vote favorite
share [g+] share [fb]

I want users to enter only 1 or 0 in a cell column in Excel 2007. Users should not be able to enter anything else than 1 or 0. How can I do this in Excel?

link|improve this question
feedback

1 Answer

up vote 3 down vote

This page has instructions on how to do it, in detail. I will quote a section though:

Data Validation dialog

link|improve this answer
Spot On! Thanks soandos for your answer – Mark Kevus Aug 18 '11 at 17:04
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.