topic I think you need to fix your… in Product Forum

Convert Value in Collection

Neel1 — Sat, 17 Feb 2018 15:31:00 GMT

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

I think you need to fix your…

Denis__Dennehy — Mon, 19 Feb 2018 20:46:00 GMT

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…

Hi Neel,…

YogitaKulkarni — Mon, 12 Mar 2018 14:27:00 GMT

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.

Hi…

PoojaPawar3 — Fri, 23 Mar 2018 14:24:00 GMT

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.