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

=IF(A1="","",A1)
instead of
=A1
--
Gary''s Student - gsnu200844


"Ruth" wrote:

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?
--
Thank-you!
Ruth