title: Excel doesn't apply mso-number-format from HTML
body: <p>Here is my situation: I have <a href="http://www.filedropper.com/excel_1" rel="nofollow noreferrer">simple Excel OOXML file</a> with Web Query connection to my server. All cells with dates have "General" horizontal alignment (no alignment) and MM/DD/YYYY format. It looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/N4ZAj.png" alt="Before refresh"></p>
  
  <p>On refresh server responses with pretty straightforward HTML:</p>
  
  <pre><code>&lt;html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"&gt;
     &lt;head&gt;
        &lt;style id="Leads_style"&gt;
          table
          {
              mso-displayed-decimal-separator:"\.";
              mso-displayed-thousand-separator:"\,";
          } 
          .cs0 { mso-number-format:\@; }
          .cs1 { mso-number-format:mm\/dd\/yyyy; }
        &lt;/style&gt;
     &lt;/head&gt;
     &lt;body&gt;
        &lt;table id="tbl_0_Leads" x:publishsource="Excel"&gt;
           &lt;tr&gt;
              &lt;td&gt;Title:&lt;/td&gt;
              &lt;td colspan="2" style="white-space:nowrap"&gt;Leads&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td&gt;Date:&lt;/td&gt;
              &lt;td align="left" colspan="2"&gt;27 Aug 2014 08:02 AM +0:00 GMT&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td&gt;&amp;nbsp;&lt;/td&gt;
              &lt;td&gt;&amp;nbsp;&lt;/td&gt;
              &lt;td&gt;&amp;nbsp;&lt;/td&gt;
           &lt;/tr&gt;
        &lt;/table&gt;
        &lt;table id="tbl_3_Leads" x:publishsource="Excel"&gt;
           &lt;tr&gt;
              &lt;td&gt;Display Name&lt;/td&gt;
              &lt;td&gt;Created Date&lt;/td&gt;
              &lt;td&gt;Last Modified Date&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td class="cs0" x:str="Darrow Mag, Mrs."&gt;Darrow Mag, Mrs.&lt;/td&gt;
              &lt;td class="cs1"&gt;04/23/2009&lt;/td&gt;
              &lt;td class="cs1"&gt;08/06/2014&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td class="cs0" x:str="q q, Prof."&gt;q q, Prof.&lt;/td&gt;
              &lt;td class="cs1"&gt;06/04/2014&lt;/td&gt;
              &lt;td class="cs1"&gt;08/06/2014&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td class="cs0" x:str="dasd dsa, Dr."&gt;dasd dsa, Dr.&lt;/td&gt;
              &lt;td class="cs1"&gt;06/16/2014&lt;/td&gt;
              &lt;td class="cs1"&gt;08/06/2014&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td class="cs0" x:str="Bouat Jerome, Dr."&gt;Bouat Jerome, Dr.&lt;/td&gt;
              &lt;td class="cs1"&gt;08/12/2014&lt;/td&gt;
              &lt;td class="cs1"&gt;08/12/2014&lt;/td&gt;
           &lt;/tr&gt;
        &lt;/table&gt;
     &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>Notice that .cs1 class in style section has <code>mso-number-format:mm\/dd\/yyyy</code>, so all dates in Excel document should look like <code>08/27/2014</code>.</p>
  
  <p>For unknown reason, Excel applies wrong format (<code>MM.DD.YYYY</code>) to date cells:
  <img src="https://i.stack.imgur.com/oJ1eo.png" alt="After refresh"></p>
  
  <p>Two cells that seem normal also have <code>MM.DD.YYYY</code> format, but Excel shows them as <code>MM/DD/YYYY</code> with left alignment because DD value is much more than maximum of MM value (yeah, that's really weird too).</p>
  
  <p>Please help. What am I doing wrong?</p>