ASP IN EXCEL, trailing zeros truncated

[BARBARA FLOYD]

Hi,

I have an ASP file which is opened in MS Excel.
I have used the "formatNumber" function to set the number
of decimals for variables which are displayed.
however Excel cuts off any zeros at the end.
e.g 4.650 displays as 4.65

the number of decimals I want to display to varies across
the page, e.g. I cant say "display the whole with 3
decimal places"

Is there any code I can put in my ASP page to stop Excel
truncating zeros at the end?

thanks for your help, any replies are really appreciated

Barbara

 

[Ray at]

http://www.aspfaq.com/5003

Ray at home