https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62755#M15805 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. Thu, 04 Jan 2018 13:36:00 GMT VaishnaviM 2018-01-04T13:36:00Z https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62755#M15805 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. Thu, 04 Jan 2018 13:36:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62755#M15805 VaishnaviM 2018-01-04T13:36:00Z https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62756#M15806 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 Thu, 04 Jan 2018 14:04:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62756#M15806 Denis__Dennehy 2018-01-04T14:04:00Z https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62757#M15807 Thank you,  Is there any way to set the cell column as number in excel and then take it to collection?  Thu, 04 Jan 2018 14:16:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62757#M15807 VaishnaviM 2018-01-04T14:16:00Z https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62758#M15808 Thank you Denis. It's working.  Thu, 04 Jan 2018 15:41:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-and-Excel-VBO/m-p/62758#M15808 VaishnaviM 2018-01-04T15:41:00Z