fomatting the display of a cell without using the format menu

J

Joseph J Monforte

I have a JSP that generates an Excel Worksheet dynamacly using.

<%
response.setContentType("application/vnd.ms-excel");
%>

This worksheet contains cells containing Excel formulas the
result of which are used by other formulas in other cells.
I need to retain the full value for the other calculations
but display the data in the cell as rounded to two places.
Is there a way to do that?

Sample fromulas:

<td bgcolor=white valign=top align=center nowrap height=12>
<font
size=-2>=IF(O<%=currentRow%>=0,0,U<%=currentRow%>*Q<%=currentRow%>/$D$11)
</td>
<td bgcolor=white valign=top align=center nowrap height=12>
<font
size=-2>=IF($Z$<%=lastRow%>>$Y$<%=lastRow%>,((Z<%=currentRow%>*$O<%=currentRow%>)/$M<%=currentRow%>),($Y<%=currentRow%>*$O<%=currentRow%>)/$M<%=currentRow%>)
</td>
 
Top