Active Server Pages to Excel Sheet

  • Thread starter Thread starter che1971us
  • Start date Start date
C

che1971us

I am generating a Report from my Access DB using Active
Server Pages (thru ADO Connection) displaying on my
browser (IE), Then i am sending the report to an Excel
Spreadsheet (Using a Hyperlink). I have a column which is
Numaric Datatype (like 4.95)and in the Excel spreadsheet
it is showing as 5 (NOT 4.95) and i need to display as it
is in my Access DB which is 4.95. How can i
prevent "Rounding" here and i checked the "Precision as
displayed" option but still it is NOT working. Help me
 
Just a stab in the dark. Is your cell format set to 2 decimal places. In
other words, when you say 'showing as 5' do you mean showing as 5.00?

Andy.
 
First, I don't know anything about ASP. But in excel, if I format a cell as
General and type in 4.95, then shrink the columnwidth enough, excel will display
it as 5.

Could it be that the column in your ASP (do you have columns in ASP???) is just
not wide enough?
 
Back
Top