Remove hours and minutes from dates in one step
<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>