validation of cells
 

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

validation of cells
 

"ArDn" wrote in message
...
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

validation of cells
 

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

"Tim Anderson" escribió en el mensaje
...
"ArDn" wrote in message
...
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

validation of cells
 

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.


In article ,
"ArDn" wrote:

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