title: HTML to Excel: How can tell Excel to treat columns as numbers?
body: <p>I need to achieve the following when opening an HTML in Excel <code>(Response.contentType="application/vnd.ms-excel")</code> :</p>
  
  <ul>
  <li>force Excel to consider content of td cells as numbers</li>
  <li>make the above so that any subsequent user-entered formulas work on these cells (when the spreadsheet is opened)</li>
  </ul>
  
  <p>So far I was successful with adding <code>style="vnd.ms-excel.numberformat:0.00"</code> to the td cells in question. The contents of the cells are correctly shown as numbers when I right click on them in the Excel, however the formulas don't work.</p>
  
  <p>If successful, that technique would be quite useful because any web Excel report could be user enhanced with appropriate formulas according to custom requirements. Thanks in advance.</p>