Convert exponential values in excel to numbers

Hi Guys,
I need help in obtaining the datatype of an excel field
and then convert it to a string

Kindly have a view on this thread

Cheers @rpatil

Hi @rpatil

use row (“ColumName”).ToString.expression=Integer.Parse(row(“ColumnName”).ToString,System.Globalization.NumberStyles.Any))

Check this

Thanks
Ashwin S