Prevent number conversion to scientific notation while exporting GridView to Excel in ASP.Net

Question

HelloExport GridView to Excel in ASPNet with Formatting using Chttpswwwyoutubecomwatchv2ryS0NeYNI0I have following queryI am using the same code to export some information in xls But I have 12 digit customer id which is automatically converted to scientific notation like  16022E11 How can I prevent so that it can be displayed as 160220010012 I have tried many things Can you please suggest solution Thanks

dharmendr · Accepted Answer

Hi thesanjaydudaYou need to add style to format numbers to stringCstring style  34ltstylegt textmode   ltstylegt34Replace the above line with belowstring style  34ltstylegt textmode  msonumberformat  ltstylegt34VBNetDim style As String  34ltstylegt textmode   ltstylegt34Replace the above line with belowDim style As String  34ltstylegt textmode  msonumberformat  ltstylegt34

Prevent number conversion to scientific notation while exporting GridView to Excel in ASP.Net

Export GridView to Excel in ASP.Net with Formatting using C#

Company

Explore

Follow us

Contact Us