title: Convert Date from text format to Custom format in Excel
body: <p>I am having Dates in Text format in Excel in below format.<br> Can you please suggest how to change it using Excel formula to a Custom format.</p>
  
  <p>The format which I got for one of my report as:</p>
  
  <pre>
  20141214
  20141215
  20141216
  20141217
  20141218
  20141219
  20141220
  20141221
  20141222
  20141223
  </pre>
  
  <p>and so on..</p>
  
  <p>I need to convert it to format as <strong>12-DEC-14</strong> (i.e. DD-MMM-YY format).<bR>
  Can you please help me with this?</p>