Excel - How to leave cell blank instead of 0?
<p>I'm not using a numerical formula. All I have is a simple reference to another cell.</p>

<pre><code>=(Sheet1!D8)
</code></pre>

<p>If that cell is blank, I want to have the cell on this page blank too, <strong>not</strong> a 0. How do I do that? I want it to appear empty to anyone, not just me, so I don't think simply editing excel settings would work? None of my google search results, including MS office site, have been helpful.</p>