validation of cells

[ArDn]

Hi!!! I'd like limit value of cells. I want that the cells contain only 1 or
0. How can I do this?

Zanks.
ARdn

 

[Tim Anderson]

Hi!!! I'd like limit value of cells. I want that the cells contain only 1 or
0. How can I do this?

Select the cell or range.

From the Data menu, choose Validation.

Settings - Allow whole number between 0 and 1.

Tim

Why Tablet PC? see http://www.itwriting.com/tablet.php

 

[ArDn]

I've tried that but the sheet is protected., so ...

 

[J.E. McGimpsey]

Followup set to microsoft.public.excel.misc.

Just make sure the cell is unlocked prior to protection:
Format/Cells/Protection, uncheck the Locked checkbox). Validation
works fine on protected sheets.