Values from referenced cells

[Wavequation]

I have a worksheet that references cells in another worksheet. Empty cells
in the referenced sheet are showing up in the second sheet as "0", rather as
an empty cell. I would like them to show up empty. Is there any way to do
this?
Thanks for your help.

 

[Max]

Instead of: =Sheet2!A1
use this: =IF(Sheet2!A1="","",Sheet2!A1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[Max]

Instead of: =Sheet2!A1
use this: =IF(Sheet2!A1="","",Sheet2!A1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[Gary''s Student]

Instead of:
=Sheet2!E29
use:
=IF(Sheet2!E29="","",Sheet2!E29)

 

[Gary''s Student]

Instead of:
=Sheet2!E29
use:
=IF(Sheet2!E29="","",Sheet2!E29)

 

[Joerg Mochikun]

Another way:
Menu Tools > Options
In the View tab uncheck the 'Zero values' checkbox. This will suppress all
zero values. This option can be set for each worksheet individually, but not
for a specific range within a worksheet.

Joerg

 

[Joerg Mochikun]

Another way:
Menu Tools > Options
In the View tab uncheck the 'Zero values' checkbox. This will suppress all
zero values. This option can be set for each worksheet individually, but not
for a specific range within a worksheet.

Joerg