Vishwas Kadamannaya

Vishwas Kadamannaya

  • 1.6k
  • 122
  • 142.2k

Covert Exponential value to number.

Jul 19 2013 5:21 AM
Hi All,

        I am reading from an Excel file and filling the details to dataset. There is a column in excel
which has values like 2.00206248286005E+15 , i want it in real numbers. First i tried to change cell format of excel to number and then it changed to 2002062482860050. and again i tried reading the excel, but the value in that column remain 2.00206248286005E+15 in data set.

I want to get real number like 2002062482860050 in/from dataset.

Thanks 
Vish.

Answers (2)