C# get excel data in exponential format?

I see what Crystal means Create an Excel document and put 312700133751 number into a cell. The formatting of the cell must be "General Excel will display 3.127E+11 instead of 312700133751 The problem is that, when you read the file with the OleDbConnection driver, the DataTable will be filled with the "3.1270013505e+011" string value (even when Excel has the "General" formatting) The problem is that 3.1270013505e+011 equals 312700133750, not 312700133751 (notice the last digit, is a zero instead of a one). This is the issue!

That the OleDbConnection is "truncating" the decimals of the number up to 10 digits, which is leaving one extra digit out of the conversion I haven't found a solution either.

I see what Crystal means. Create an Excel document and put 312700133751 number into a cell. The formatting of the cell must be "General".

Excel will display 3.127E+11 instead of 312700133751. The problem is that, when you read the file with the OleDbConnection driver, the DataTable will be filled with the "3.1270013505e+011" string value (even when Excel has the "General" formatting). The problem is that 3.1270013505e+011 equals 312700133750, not 312700133751 (notice the last digit, is a zero instead of a one).

This is the issue! That the OleDbConnection is "truncating" the decimals of the number up to 10 digits, which is leaving one extra digit out of the conversion. I haven't found a solution either...

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.