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

Will make the cell look blank.


Gord Dibben MS Excel MVP

On Wed, 20 Jun 2007 13:05:38 -0700, Bouket
wrote:

I am linking cells from one worksheet to another. When there is nothing
entered yet in the worksheet that I want the into to carry over from, it
is inserting a 0 in the cell (but shows my formula in the top fx box).
Do you know how to get rid of that 0 so the cell is completely blank
until the info is entered on the worksheet it is linked to?