displaying exact data in ms-excel from asp.net code

Question

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,pls help. And the datatype i used for register number is "long".

lordkain · Accepted Answer · 2013-08-08 07:46:45Z

1

This is just the format of the cell (represention)

Look at this tutorial to change represention

answered Aug 8, 2013 at 7:46

lordkain

3,1191 gold badge16 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

displaying exact data in ms-excel from asp.net code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related