Convert Value in Collection

[Neel1]

Hi- Please suggest How to convert 1.2239E+13 to proper number in one of collection column.

[Denis__Dennehy]

I think you need to fix your data source rather than the collection: https://support.microsoft.com/en-gb/help/2643223/long-numbers-are-displ…  

[YogitaKulkarni]

Hi Neel,   If you are accepting this value from Excel using OLEDB, then you can just format the column to text in the query, it should take that value as it is. Then you can convert that value to number again using a ToNumber Conversion function. Example : ""SELECT [A], str() AS [B1] from [SHEET1$]"" Here Column is the column where above given value can appear.  

[PoojaPawar3]

Hi How to change column data type of collectiono? I am taking data from excel into collection, which comes under text format but I want to sort the column so need to convert text column to number. Excel consist more than 1000 rows so converting each row into number will be time consuming. Kindly advice.