ASP IN EXCEL, trailing zeros being truncated

[BARBARA FLOYD]

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

Barbara

[Ray at]

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

Ray at home

"BARBARA FLOYD" <anonymous@discussions.microsoft.com> wrote in message
news:0bfa01c3a83c$158b4a20$a101280a@phx.gbl...

> 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
>
> Barbara