Formatting value in cell

[rohith.prabhu]

Hello @tftlover ,

Have a look at the below link, this may help you to format the excel cell. (you may need to change the format as per your need here)

Excel cell formatting control

Instructions: use the invoke VBA activity inside of excel scope activity save the below code in a text file save it as .txt file Sub reformat_cells(in_range As String) Range(in_range).Select Selection.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)" End Sub Invoke VBA activity parameters Code File Path => the text file with the VBA Code EntryMethodNme => the method or Sub name in the txt file => "reformat_cells" EntryMethodParameters => this is the range you…

Regards,
Rohith