title: Date formatting issues when opening CSV
body: <p>I have a CSV report that contains a date/time field, but when I open it in Excel, it seems to try and auto format the date and time, but has some issues with certain dates.</p>
  
  <p>If I open the CSV file in Notepad, all of the dates follow the same format, which is something like <code>2/1/17 12:00 AM</code> (M/D/Y). However I get 2 different results, depending on the date. If the day is less than <code>12</code>, it will display in yyyy-MM-dd (for example: <code>2002-01-17  12:00:00 AM</code>), which is my system date format. If the day is > 12, it will display as <code>10/31/16 12:00 AM</code>, which is exactly how it is formatted in the CSV source. So, in those cases it looks like it is being treated as text.</p>
  
  <p>If I change my short date format to M/d/y, then everything works fine, however I believe we have standardized on yyyy-MM-dd, and this will need to be used by multiple people, so changing the date format for any users who need to use this spreadsheet isn't a great option.</p>
  
  <p>Ideally, what I would like to do is prevent this from happening altogether, if possible by not having the dates be automatically formatted when the document is opened. Is that possible?</p>