title: Excel default date time format yyyy-mm-dd hh:mm:ss versus yyyy-mm-dd hh:mm
body: <p>I'm using Excel 2010 or Excel 2007 to import CSV file with date/time information.
  The time stamp in my CSV file have the following format: yyyy-mm-dd hh:mm:ss. (ex: 2015-07-17 12:34:56)</p>
  
  <p>My problem is that Excel seems to auto-detect that the field is a date/time and it is removing the second. Therefore it shows my data as: "2015-07-17 12:34" without the second.
  Then, when I save my file again in CSV the second are discarded and not present in the CSV anymore !</p>
  
  <p>I find it very time consuming to change the custom cells format of all my files from "yyyy-mm-dd hh:mm" to "yyyy-mm-dd hh:mm:ss".</p>
  
  <p>Is there a way to change the default date/time format in Excel setting or Windows registry?</p>
  
  <p>What is the best (correct) way to force Excel to keep the second when I open and save a CSV file with data/time information in it.</p>
  
  <p>Thanks,
  ssinfod</p>