~Try~ preceding the values with a ' in your response.
Ray at home
"BARBARA FLOYD" <email@example.com> wrote in message
> 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