title: excel linking cells and format changes
body: <p>I want to link the dates(in this format: <strong>mm/dd/yy</strong>) listed in cell in column 1 in sheet 1 to column 3 in sheet 2(in this format:<strong>yyyy</strong>). Ive done that with the simple link: <strong>='Unapplied Report'!E50</strong> , and then I did a format cell to just display the year(<strong>yyyy</strong>). It worked well and I applied the link down to the whole column. However, when there is a blank cell in column 1 from sheet 1 for some reason instead of linking the blank cell to column 3 in sheet 2, it displays year <strong>1900</strong>. What method would be best to make it show the blank cell it is supposed to show? Thanks in advance for your help.</p>
  
  <p><strong>EDIT:</strong>
  Thanks for your help guys, just one last question.
  How would I apply the <strong>IF(ISBLANK</strong> formula to this <strong>=CONCATENATE(TEXT('Unapplied Report'!A3,"0000"),TEXT('Unapplied Report'!C3,"000"),TEXT('Unapplied Report'!D3,"0000"))</strong> without bringing up any errors?
  Thanks again in advance for your help.</p>