Excel Zero Values

[Paul Findlay]

i have a spreadsheet with cell values that are taken from
another sheet so each cell is a formula. The cells from
the primary sheet that don't have a value in them come
through as 0.00, and with zero values turned off I can't
see them.

Problem is that when I turn zero values on, it turns
itself off after a cell value is changed.

How can I make it stay on?

 

[Dave Peterson]

Instead of toggling the zero values, how about adjusting your formula:

instead of =sheet2!a1
use =if(sheet2!a1="","",sheet2!a1)