title: Date format in CSV file strange behaviour
body: <p>I have a .csv file that is created generated using some legacy software. There is no way to look inside the code at how or what its doing to produce the csv file.</p>
  
  <p>My issue is that the date field format is behaving strangely.
  The .csv file is storing the date in the following format.</p>
  
  <pre><code>MM-dd-yyyy HH:mm:ss.SSS
  </code></pre>
  
  <p>Looking in the file in notepad (raw data) we get a list of columns like this:</p>
  
  <pre><code>"01-12-2013 14:23:38.000",146.199997
  "01-12-2013 23:20:29.000",146.199997
  "01-13-2013 17:59:23.000",152.299988
  "01-13-2013 18:08:40.000",147.300003
  "01-13-2013 18:25:52.000",156.000000
  "01-13-2013 18:35:14.000",146.300003
  "01-13-2013 18:44:56.000",148.500000
  "01-13-2013 18:56:41.000",151.699997
  </code></pre>
  
  <p>NOTE: I have stripped out the remaining columns to make it easier on the eye so we are only seeing the first 2 columns in the .csv file.</p>
  
  <p>Now when I open this file in Excel 2010 version 14.0.6023.1000 (32-bit) I get date format problems.</p>
  
  <p>Firstly if I just open the file I get blocks of mixed date formatting like this: </p>
  
  <p><a href="https://i.stack.imgur.com/69lza.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/69lza.png" alt="Formatting 1"></a></p>
  
  <p>And this:</p>
  
  <p><a href="https://i.stack.imgur.com/JumbA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JumbA.png" alt="Formatting 2"></a></p>
  
  <p>I can see that Excel is getting confused when the day value is switching from 12 to 13. If i then try to change the formatting to fix the issue using the following cell formatting settings:</p>
  
  <p><a href="https://i.stack.imgur.com/X7xm2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/X7xm2.png" alt="Column Formatting"></a></p>
  
  <p>Then I get the following displayed in the column when the day is less than 13:</p>
  
  <p><a href="https://i.stack.imgur.com/orxiE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/orxiE.png" alt="Date Format 3"></a></p>
  
  <p>And the following format when the day is greater than or equal to 13:</p>
  
  <p><a href="https://i.stack.imgur.com/gde7w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gde7w.png" alt="Date Format 4"></a></p>
  
  <p>Any help would be really appreciated on this as I am now completely out of ideas.</p>
  
  <p>NOTE: I have also tried copying the contents of the .csv file into another file but the same things occur in the new file.</p>