https://community.blueprism.com/t5/Product-Forum/Cast-Collection-s-Data-Type/m-p/47633#M3337 Try creating a new collection with the same column names as the original, but change the text column to the number data type. Then use a calculation with the old collection as the expression and the new collection as the Store In. If all the text values can be cast to a number then this direct cast should work. Note that if any text values are blank or non-numeric then it won't work. Also remember to disable logging on the calculation. Mon, 26 Feb 2018 14:08:00 GMT John__Carter 2018-02-26T14:08:00Z https://community.blueprism.com/t5/Product-Forum/Cast-Collection-s-Data-Type/m-p/47632#M3336 Hi Guys. Please let me know if you have any idea for casting data type of collection's columns from "Text" to "Number". I understood using "Loop" and "Calculation"(ToNumber Function) is one of the method to solve this issue but this way requires a ton of time  especially for the collection which have more than 1000 rows. Should I use any "Utility VBO" or do I have to create new VBO by using Code stage..?   Thank you in advance.   Kota   Mon, 26 Feb 2018 13:10:00 GMT https://community.blueprism.com/t5/Product-Forum/Cast-Collection-s-Data-Type/m-p/47632#M3336 KotaSaito 2018-02-26T13:10:00Z https://community.blueprism.com/t5/Product-Forum/Cast-Collection-s-Data-Type/m-p/47633#M3337 Try creating a new collection with the same column names as the original, but change the text column to the number data type. Then use a calculation with the old collection as the expression and the new collection as the Store In. If all the text values can be cast to a number then this direct cast should work. Note that if any text values are blank or non-numeric then it won't work. Also remember to disable logging on the calculation. Mon, 26 Feb 2018 14:08:00 GMT https://community.blueprism.com/t5/Product-Forum/Cast-Collection-s-Data-Type/m-p/47633#M3337 John__Carter 2018-02-26T14:08:00Z