title: Excel vba - convert string to number
body: <p>So, I used the left function to take the first 4 characters of a string and I need to run a vlookup with it, but it won't find the match because it's looking through numbers. </p>
  
  <p>I want to do this in a macro, so I'm not sure about the syntax. Can someone help?</p>