title: Excel #Value error when using DATEVALUE function
body: <p>In cell <code>A2</code> I have <code>7/21/2014 12:44:36 PM</code></p>
  
  <p>When I use <code>DATEVALUE(LEFT(A2;FIND(" ";A2)-1))</code> I get the error <code>#VALUE</code>.</p>
  
  <p>When I use <code>LEFT(A2;FIND(" ";A2)-1)</code> I get <code>7/21/2014</code>.</p>
  
  <p>What do I need do that function <code>DATEVALUE(LEFT(A2;FIND(" ";A2)-1))</code> to return just the date?</p>