return a " " for null values
 

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

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

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