I created a link between two workbooks, but my "target" workbook returns "0" in the cells that should be blank (i.e. blank cells in my "source" workbook now have a 0 in them in my "target" workbook). My "source" workbook is all text with dates.
Is there a quick and easy way to replace all 0 results in the target workbook with blank cells? I tried doing a "find/replace" in the target workbook, but that created errors.
Is there a quick and easy way to replace all 0 results in the target workbook with blank cells? I tried doing a "find/replace" in the target workbook, but that created errors.
