Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

The NumberFormat property represents the number format (expressed as a text string) of the Range object

Sub numFormat()     Columns("A:A").NumberFormat = "0.00%" End Sub