David
Be aware that these would not be true NULL values, just look blank.
Gord Dibben Excel MVP
On Fri, 21 Jan 2005 15:31:37 +0100, "Harald Staff"
wrote:
Hi David
Either use formulas like
=IF(Sheet1!A1="","",Sheet1!A1)
or uncheck "zero values" in Tools Options, View.
HTH. Best wishes Harald
"David#" skrev i melding
...
I have cells on "Sheet1" whose value is linked to cells on "Sheet2"
(direct
1 to 1 link).
If i have nothing in the Sheet 2 cells, I need blank cells on Sheet 1,
but,
of course, I get a "0"... how can I have sheet 1 show a null value.
Thanx
- David
|