Linking sheets how do I display the zeros (0) as blank cells
 

I have a blank cell on the first worksheet that I am linking to a second
worksheet - when I link the two worksheets the blank cell now displays a zero
(0) on the linked sheet (second worksheet). I want this linked cell to be
displayed as blank with no zero (0) in the cell, how can I do this?

Linking sheets how do I display the zeros (0) as blank cells
 

Try something like this:

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

--
Biff
Microsoft Excel MVP


"kat106" wrote in message
...
I have a blank cell on the first worksheet that I am linking to a second
worksheet - when I link the two worksheets the blank cell now displays a
zero
(0) on the linked sheet (second worksheet). I want this linked cell to be
displayed as blank with no zero (0) in the cell, how can I do this?