title: Python Openpyxl writing date to excel as short date
body: <p>I am trying to write dates to an excel file using Openpyxl.  I am using the following lines to write the date.</p>
  
  <pre><code>dttm = datetime.datetime.strptime(ls25Dict[cell.value][2], "%m/%d/%Y" )   
  ws1['B'+ str(cell.row)].value = dttm
  </code></pre>
  
  <p>This writes the date to excel but in the wrong format.  This is the output:</p>
  
  <p>2018-01-09 0:00:00</p>
  
  <p>I am trying to get it to be 1/9/2018.  Basically change the format to Short Date in excel.  </p>
  
  <p>Anyone know how to change it before the date is written to excel?</p>