title: How to format cell with datetime object of the form 'yyyy-mm-dd hh:mm:ss' in Excel using openpyxl
body: <p>So, given:</p>
  
  <pre><code>dttm = datetime.datetime.strptime("2014-06-23 13:56:30", "%Y-%m-%d %H:%M:%S")
  ws['A1'] = dttm
  </code></pre>
  
  <p>The result in excel is that the correct date-time is written to the cell (you can see it where you'd input formulas). BUT, the cell display format is only MM/DD/YYYY.</p>
  
  <p>I need the cell to display like "6/23/2014 13:56" instead of just "6/23/2014". </p>
  
  <p>How can I explicitly format the cell to accomplish this?</p>
  
  <p>Thanks!</p>
  
  <h2>Edit</h2>
  
  <p>@alecxe This solution works and is exactly what I asked for. I would like to be able to save styles like the solution by @Woodham. Unfortunately it raises a typeError (see comment). Any suggestions?</p>