title: Excel XML, how can I get Excel to display my DateTime field in yyyy-MM-dd format?
body: <p>I generate an XML file through C#, and the relevent part looks like this</p>
  
  <pre><code>&lt;ss:Cell&gt;
      &lt;ss:Data ss:Type="DateTime"&gt;2009-01-18T00:00:00.000&lt;/ss:Data&gt;
  &lt;/ss:Cell&gt;
  </code></pre>
  
  <p>However it displays in excel as a number , like 41249 that bears no resemblence to the original date. If I right click the cell, and change the format to dd/MM/yyyy or whatever, then it displays the correct date. Anyone know how I can set the format in the XML for how the date is displayed? The data is there, it's just being displayed incorrectly.</p>