Linked cell display issue.

Hello Excel experts;
I have a worksheet in one workbook that has cells linked to another worksheet in a different workbook. If there is no data in the primary cell the default display is "0". How can I have the linked cell remain empty if there is no information. This is a real problem for cells that contain dates. For example, the cell linked to ='[TEST CREW 2.xls]T-0'!$BJ$366, displays 1/0/1900 if there is nothing in [TEST CREW 2.xls]T-0'!$BJ$366.
Thanks in advance for your help.

You can double evaluate the formula eg:

=IF(cell="","",cell)

but note that with dates/numbers this means some cells will contain numbers (the date) whereas others will contain text (Null)

The downside to this approach is that you're processing the link/formula potentially twice over - depending upon the efficiency of what you're doubling up on this could be bad news.

If it's an aesthetic issue then you can use a Custom Format, eg for Date cells: m/d/yyyy;;;@

this will "mask" the 0 so it appears as blank and does not print, however, the 0 will remain as the underlying cell value.

Extending the format notion further...

If zeroes are never valid anywhere on your sheet you can toggle the "show a zero in cells that have a zero" option in Excel Options but if you ever need to display a 0 this will not be viable.

=if('[TEST CREW 2.xls]T-0'!$BJ$366,'[TEST CREW 2.xls]T-0'!$BJ$366,"")
or turn of the display zero in excel options
or custom format the cells
0;-0;;@
or conditional format white text if cell = 0