When you have two sheets in one workbook linked together
and on the original you have no entry in the cell, how do
you get rid of the "0" that appears on the linked sheet?

Hi Stacy
you may use the following formula in cell A1 on the second sheet (where
sheet1 is the linked sheet)
=IF('sheet1'!A1="","",'sheet1'!A1)
copy down/to the right

--
Regards
Frank Kabel
Frankfurt, Germany

Stacy Taylor wrote:
When you have two sheets in one workbook linked together
and on the original you have no entry in the cell, how do
you get rid of the "0" that appears on the linked sheet?

One way:

=IF(Sheet2!A1="","",Sheet2!A1)


In article ,
"Stacy Taylor" wrote:

When you have two sheets in one workbook linked together
and on the original you have no entry in the cell, how do
you get rid of the "0" that appears on the linked sheet?

Stacy

You can also go to menu, tools, options, view tab and
uncheck the zero option box.

Charlie O'Neill
-----Original Message-----
When you have two sheets in one workbook linked together
and on the original you have no entry in the cell, how do
you get rid of the "0" that appears on the linked sheet?
.