Hi
Something like this : =if(sheet1!a1="","",your formula. change range to your
need.
HTH
John
"OC" wrote in message
...
I have two spreadsheets linked together as vacation planners....the
worksheet
cells that the link is copied to default to "0"....I am wondering if there
is
a way to still have the sheets linked but that the cell stays blank vs. a
"0"
and would only reflect the actual entry once entered in the main
spreadsheet.

Thank you,