links

[Ruth]

Hi there

I have a file that has several worksheets that I have created a worksheet
that compiles the information from the various worksheets using links. When
there is no date entered in the source worksheet, there is a zero in the
compiled data worksheet. Is there a way to get rid of the zero?

 

[Gary''s Student]

What you are seeing is true even inside a worksheet. To remove the zero use:

=IF(A1="","",A1)
instead of
=A1

 

[Ruth]

Ok thank-you!

I was hoping for an easy way, but I imagine this has to be typed into each
linked cell.

 

[Jim Cone]

If your version of Excel has a menu bar...
Tools | Options | View (tab)... uncheck Zero values
--
Jim Cone
Portland, Oregon USA



"Ruth"
<[email protected]>
wrote in message
Hi there
I have a file that has several worksheets that I have created a worksheet
that compiles the information from the various worksheets using links. When
there is no date entered in the source worksheet, there is a zero in the
compiled data worksheet. Is there a way to get rid of the zero?

 

[Gord Dibben]

You should be able to just drag/copy unless you are dealing with
non-contiguous cell references.


Gord Dibben MS Excel MVP