Create Excel from colfusion data

[Idee]

I am trying to output a query to Excel by using <cfcontent type='application/vnd.ms-excel'>

I output the data in html <table and <td etc. It outputs the content nicely except the number 8111111111111111 becomes 8.11111E+15 and if I try to format it in Excel, it formats it but becomes 8111111111111110 i.e the last digit becomes 0 instead of 1 in this case. How should I format it so that as I open the Excel, it should display it as 8111111111111111?

Thanks

 

[FALCONSEYE]

do you get those values from a query? if so, you can use NumberFormat() function...

 

[Idee]

No, I get these values only once I write the values in Excel. My query returns the correct values.

Thanks