MrExcel Publishing
Your One Stop for Excel Tips & Solutions

PasteLinking - I don't want to use or display a default value in destination cell

Posted by Kelwyn Yeo on September 18, 2001 1:42 AM

Hi I need help with this:

I have paste linked dates from several sources to compile onto a summary sheet. If the source cell is empty, the destination cell shows as 0/01/00 (as this is the date format of the cell I want). As some of the source dates will not be entered, the minimum date in my summary sheet will therefore be 0/01/00.

Is there a way to calculate the minimum date, to ignore the value if it is 0/01/00 in the destination cell. Better still, when paste linking, if the source cell is empty, can the destination cell also display as empty rather than a 0 or value. That way calculations will not include these paste linked default values.

Posted by Tom Urtis on September 18, 2001 2:07 AM

At least 2 options for you:

Either try modifying the paste link formula from:


In the destination workbook, try clicking on Tools > Options > View tab, and towards the bottom in the "Window options" section deselect "Zero values".

Tom Urtis