Collection and Excel VBO

[VaishnaviM]

Hi,  Can you please help me with the logic.  I am taking data from excel and storing it into collection.  One of the field is in text but the values are in dollars. I need to sort it according to dollars. But it is getting sorted as text. How can I change the field to number in collection? Or any other way to do?  Thanks.

[Denis__Dennehy]

This kind of thing usually takes a bit of playing about and experimentation to solve, no one will have the answer off the top of their heads.   I created a collection with a text field stroring numeric data I created another collection with no data in where the same field was a number field I cast one collection to the other using a calculation stage I then sorted the second collection with the number field

[VaishnaviM]

Thank you,  Is there any way to set the cell column as number in excel and then take it to collection? 

[VaishnaviM]

Thank you Denis. It's working.