You could link the checkbox to another cell (hidden or well out of th
line of sight) and then put this formula in the cell where you want i
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, jus
leave it as true/false and put the double negation in your formula.



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