title: excel string comparison is failing when it should not
body: <p>When I do <code>=RIGHT(DATA!$A$2:$A$1501,1)</code> I get the value 3. When I do <code>=$B$5</code> I get the value 3. When I do <code>=RIGHT(DATA!$A$2:$A$1501,1)=$B$5</code> I get the value FALSE.</p>
  
  <p>How the f%^k can 3 not equal 3. Is this a data type issue? Do I need a cast? If so how?</p>