Thank you very much! I put it in the formula and it works
great! Thanks again!


-----Original Message-----
You could link the checkbox to another cell (hidden or
well out of the
line of sight) and then put this formula in the cell
where you want it
to be 0 or 1.

= --A1000

(thats equals, minus, minus, your linked cell).

The double negation converts a logical (true/false) to a
number (0/1).
If you are doing this to be able to use the cell in a
calculation, just
leave it as true/false and put the double negation in
your formula.

K


---
Message posted from http://www.ExcelForum.com/

.