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<%=cu rrentRow%/$D$11)
</td
<td bgcolor=white valign=top align=center nowrap height=12
<font
size=-2=IF($Z$<%=lastRow%$Y$<%=lastRow%,((Z<%=curren tRow%*$O<%=currentRow%)/$M<%=currentRow%),($Y<%=currentRow%*$O<%=current Row%)/$M<%=currentRow%)
</td