title: Adding formatting to excel cell
body: <p>XSL: 1.0</p>
  
  <p>I have an XSL script that is inputting a formula into an excel cell that will be filled in dynamically by the formula. The contents of the cell will just be numbers (specifically hours). My goal is to set this new cell to format category of Custom and type "[h]". Ex: Format="[h]"</p>
  
  <p>XSL:</p>
  
  <pre><code>&lt;Cell ss:StyleID="cell_data" ss:Formula="=SUM(R[0]C[+1]-R[0]C[-2])"&gt;
  &lt;/Cell&gt;
  </code></pre>
  
  <p>I have tried to add a <code>ss:Format</code> with <code>ss:Type="Number"</code> to this via a <code>&lt;Data&gt;</code> tag but it seems that isnt valid.</p>
  
  <p>The Style is:</p>
  
  <pre><code>&lt;Style ss:ID="cell_data"&gt;
    &lt;Font ss:Color="#000000" ss:FontName="Calibri"/&gt;
    &lt;Interior ss:Color="#FFCC99" ss:Pattern="Solid"/&gt;
    &lt;Borders&gt;
     &lt;Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/&gt;
     &lt;Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/&gt;
     &lt;Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/&gt;
     &lt;Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/&gt;
    &lt;/Borders&gt;
  &lt;/Style&gt;
  </code></pre>
  
  <p>Any advice on how to change this cell would be most helpful.</p>