Hi, I'm linking two workbooks together, namely a column in one workbook that is linked to another column. The source column is populated with dates although some cells are blank. My problem is when I link this via a Paste Link set up, where the blanks occur in the source excel doc it copies over as 0/01/00 instead of a blank cell to my destination workbook. Does anyone know the formula to correct this so that blank cells stay as blank cells in the column? Hope this makes sense. Thanks.
Bookmarks