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 asp.net 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".
Posted
Comments
[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