title: Number representation by Excel
body: <p>I'm building a VBA program on Excel 2007 inputing long string of numbers (UPC). Now, the program usually works fine, but sometimes the number string seems to be converted to scientific notation and I want to avoid this, since I then VLook them up.</p>
  
  <p>So, I'd like to treat a textbox input as an exact string. No scientific notation, no number interpretation.</p>
  
  <p>On a related side, this one really gets weird. I have two exact UPC : both yield the same value (as far as I or any text editor can tell), yet one of the value gives a successful Vlookup, the other does not. </p>
  
  <p>Anybody has suggestions on this one? Thanks for your time.</p>