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