Excel Zero Values

  • Thread starter Thread starter Paul Findlay
  • Start date Start date
P

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?
 
Instead of toggling the zero values, how about adjusting your formula:

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