Convert only few Excel Column to Number format

[mayankjha986 (Mayank986)]

Having an Excel file Where i need to convert the columns “T,U,V” to number format.

I have tried using VBA but it didn’t works while running the bot,

ActiveSheet.Range(“T:V”).NumberFormat=“0.00”

So looking for any activity within UiPath to convert the column format.
Please Suggest.

[Palaniyappan (Palaniyappan P)]

Hi
Check with this custom component

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Cheers @mayankjha986

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

Could you please try with the below code it will convert values from string to number format in case the following statement ActiveSheet.Range(“T:V”).NumberFormat=“0.00” not working.

For Each cell In Worksheets(“Your sheet Name”).Range(“T:V”).Cells
cell.Value = cell.Value
Next

Regards,
Kirankumar.

[mayankjha986 (Mayank986)]

@Palaniyappan Thanks for the reply

But i am looking for any inbuilt UiPath Activity. Can’t install any other package as the one suggested.
Please suggest is any of them can be used.