A ArDn Oct 16, 2003 #1 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
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
T Tim Anderson Oct 16, 2003 #2 ArDn said: Hi!!! I'd like limit value of cells. I want that the cells contain only 1 or 0. How can I do this? Click to expand... 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 said: Hi!!! I'd like limit value of cells. I want that the cells contain only 1 or 0. How can I do this? Click to expand... 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
J J.E. McGimpsey Oct 16, 2003 #4 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.
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.
