a library of things I use regularly but can never find when I need them. I will add to it over time.
#datetime(fieldname, "mm/dd/yyyy")#
#DOLLARFORMAT(fieldname)#
Excel formatting:
color alternating rows
<tr bgcolor="###iif(currentrow MOD 2,DE('ffffff'),DE('ffff99'))#">
number as text in excel
<td style="mso-number-format:/@">#field#</td>
