title: Match function with dates
body: <p>I have date column on two different sheets and when I run a match function (part of index match) it comes up N/A, because Excel says the two cells that have the same date in them are not equal to each other. When I change the format of one of the columns it changes to five numbers (which I know that is what excel uses to track dates), but the other column does not do this, it is simply text. </p>
  
  <p>My question is, how to I get excel to forget about the five number date format and just give me text? Paste special values doesn't get it done like I thought it would.</p>