Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Convert Value in Collection

Neel1
MVP

‎17-02-18 03:31 PM

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

Denis__Dennehy
Level 15

‎19-02-18 08:46 PM

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…  
0 Likes

YogitaKulkarni
Level 3

‎12-03-18 02:27 PM

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.  
0 Likes

PoojaPawar3
Level 2

‎23-03-18 02:24 PM

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.
0 Likes