How to convert a Column format from general to number format with 2 decimal places

Suggest a method for this
Screenshot 2022-04-29 152727

is this activity will it change the full column of the excel??

Yes, we can specify the range for it

Hi @Gopikrishna_S
something like this

image
you can mention the range

Sub FormatColumn()
Sheet1.Range(“C2”, “C50000”).NumberFormat = “0.00”
End Sub

use above code in invoke VBA activity.
Here C is the column I want to do formatting. You can change this as per your need.
Entry point will be FormatColumn instead of Main.
If this is useful, mark this as solved.