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

[Gopikrishna_S]

Suggest a method for this

[ppr (Peter)]

Format Cells

[Gopikrishna_S]

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

[ppr (Peter)]

Yes, we can specify the range for it

[nikhil.girish]

Hi @Gopikrishna_S
something like this

you can mention the range

[c3f1e68294fdcf4a1f0a817ca (Rakesh Gupta)]

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.