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
|