format column in Excel through vb?

[butchkmd]

I need to change the format of a column in excel to "number" from "general" and have had no luck getting it to work. Below is the code.
Any suggestions?


sht.Range("d:d&quot.ColumnWidth = 15
sht.Range("D3&quot.Value = "CLAIM #"
sht.Range("D3&quot.Font.Bold = True
sht.Range("D3&quot.Font.Size = 11
sht.Range("D&quot.FormatConditions.NumberFormat = "Number"

 

[CajunCenturion]

You might want to try actually setting the .NumberFormat property to a display mask.

.NumberFormat = "###,###"

Also, it looks like you want to set this format for the entire column, so you might want to try

sht.Columns("D&quot.NumberFormat = "###" Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein