ASP IN EXCEL, trailing zeros being truncated -- inetserver asp components

BARBARA FLOYD
11/11/2003 2:10:50 AM

Hi,

I have an asp file which opens in Microsoft Excel.
I have used "FormatNumber" function to force variables I
display to be a certain number of decimal places.
However, Excel cuts off any zeros at the end.
eg. the number 5.640 displays as 5.64, even though I used
format number to 3 decimal places.

The number of decimal places I need to use throughout the
page vaires, i.e I cant say "the whole page can be of 3 dp"

How can I code the ASP page to stop Excel truncating the
zeros at the end?

Thanks very much for your help!
Any advice is really appreciated

Ray at <%=sLocation%
11/11/2003 5:30:06 AM

~Try~ preceding the values with a ' in your response.

Ray at home

[quoted text, click to view]

inetserver asp components : ASP IN EXCEL, trailing zeros being truncated