I'm setting up a C # Requests report, I'm using the Microsoft.Interop.Excel library and I'm facing a problem:
It is necessary to include the Order number in this report and when it is presented in Excel it comes in Exponential Format: 7,80005E+12 , the original being: 78000496698755 .
I read on the Web that putting an Apostroph before the text would come correct, the problem is that this number is necessary for other conversions inside and outside the program file and this apostroph is barring some of these conversions.
My question is: Is there any kind of formatting that I can put for the content to come correctly, I tried the code below, but to no avail:
NumberFormat = "@";