return a " " for null values

[David#]

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

 

[Harald Staff]

Hi David

Either use formulas like
=IF(Sheet1!A1="","",Sheet1!A1)
or uncheck "zero values" in Tools > Options, View.

HTH. Best wishes Harald

 

[Gord Dibben]

David

Be aware that these would not be true NULL values, just look blank.


Gord Dibben Excel MVP