title: Removing Timestamp from date (text format)
body: <p>I have an Excel macro getting 1000+ records from database.</p>
  
  <p>The dates in the data are fetched with timestamp and is in text format. I need to format the dates in DD-MON-YYYY format.   </p>
  
  <p>Input:<br>
  2016-04-03 00:00:00</p>
  
  <p>Output:<br>
  03-Apr-2016</p>
  
  <p>I tried:</p>
  
  <ol>
  <li><p>Casting all the date columns to date in the DB query - The macro keeps running for forever and excel stops responding.</p></li>
  <li><p><code>TRUNC(TO_DATE('PROJECT_START_DATE'),'YEAR')</code> in query - Throws error</p></li>
  <li><p><code>INT(Cell)</code> or <code>DateTime(Cell)</code> in excel - Throws error</p></li>
  </ol>