leading zeroes for xls templates

Code for XLS templates that require leading zeros in the output value of a column.

(blue star)

Instructions

Number-based solution:

<style type="text/css">
.kielsCoolCustomFormat{
     mso-number-format: "0000";
}
</style>
<table>
          <tbody>
                   <tr>
                     <td class="kielsCoolCustomFormat">100</td>
                   </tr>
          </tbody> 

</table>

Text-based solution:

<table>
     <tbody>
          <tr>
           <td>=TEXT("100", "0000")</td>
          </tr>
     </tbody>
</table>

<lineitemsSOQL>
<class>table249</class>
<column>id</column>
<column>name</column>
<column prefix="&nbsp;" >ordernumber__c</column>
<soql>select id, name, ordernumber__c from opportunity</soql>
</lineitemsSOQL>
}}-->

Highlight important information in a panel like this one. To edit this panel's color or style, select one of the options in the menu.