Subin Thomas

Subin Thomas

  • 459
  • 4.8k
  • 79.9k

problem in data after exporting to excel

Dec 3 2019 1:05 AM
i have an employee detail which im generating excel sheet on a button click reportviewer is generated from which user can take excel as well as pdf file.
 
but i have problem in excel i have a column of Account number which can be ranging from 15 to 16 digit account number.
 
Excel doesnt allow digit more then 15 the 16th digit will be replaced with 0 if we try to enter 16th digit.
 
so the account number with 16 digit is displayed but when clicked it changes to some exponential form
 
how to overcome this, any changes that can be made in RDLC ?