Link them all to cell? Eg.

=IF(G9=0,G9,something_else)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"LPhiEKicKMyDog" wrote in message
...

Good Afternoon,

Does anyone know how to zero out the values in a table? I'm using
a separate cell outside of the table as an "on/off" switch, and I want to be
able to make all the values in my table display "0" once I make this
separate cell's value = to zero as well.

Thanks,
Vivek