title: Remove hours and minutes from dates in one step
body: <p>I always get the dates like shown in <strong>Column A</strong>, but I need them as shown in column C. How can I do it without having to create <strong>column B</strong> helper? I need that because the hours and minutes mess up what I want to achieve after this.<br/></p>
  
  <p><strong>Column A</strong></p>
  
  <p>Time with hours and minutes:</p>
  
  <pre><code>22/05/2015 14:57
  11/06/2015 15:40
  28/05/2015 08:27
  26/05/2015 14:51
  25/05/2015 14:18
  25/05/2015 15:51
  </code></pre>
  
  <p><strong>Column C</strong></p>
  
  <p>Time without hours and minutes:</p>
  
  <pre><code>22/05/2015 
  11/06/2015 
  28/05/2015 
  26/05/2015
  25/05/2015
  25/05/2015
  </code></pre>
  
  <p>I managed to solve this by creating a column B that converts to text <br/></p>
  
  <pre><code>=Text(A2;"DD-MM-AAAA")
  </code></pre>
  
  <p>and then column C converts text to value<br/></p>
  
  <pre><code>=Data.value(B2)
  </code></pre>
  
  <p>While this process works, it causes me a lot of unnecessary data and I wonder if I can do this automatically with a <a href="/questions/tagged/vba-excel" class="post-tag" title="show questions tagged &#39;vba-excel&#39;" rel="tag">vba-excel</a> macro in one step. I also want the number dates in column C always equal to the number of dates in <strong>column A</strong> and dates in the same order.</p>