Click here to Skip to main content
15,877,967 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have created an website,which stores data into an ms-excel sheet from the webpage,the problem is,all other column values except the first column(register number)are correct.when we open the sheet it displays a value "2.11511E+11" in the register number column.Why so? Im new to using ms-excel,plz help. And the datatype i used for register number is "long".
[no name] 8-Aug-13 5:19am    
PLease post the code snippet for displaying the data in the excel so that er can help you.

1 solution

I found the solution,

This is just the format of the cell (represention)

Look at this[^] tutorial to change represention
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900