excel cell format change

[TcoUpLoad]

Hi,
Anyone knows how i can change cell format in excel with a code line?

[QVeen72]

Hi,

Select the cell and change format :

For Number formatting
[code=vb]
Range("D8").Sel ect
Selection.Numbe rFormat = "0.00"
Columns("D:D"). ColumnWidth = 15
[/code]

Date Formatting :
[code=vb]
Range("D11").Se lect
Selection.Numbe rFormat = "d-mmm-yy"
[/code]

REgards
Veena

[TcoUpLoad]

Hi,
In that order for time will be samething like

.....numberform at="hh:mm:ss"

right?

[QVeen72]

Hi,

U can try this :

[code=vb]
Range("D8").Sel ect
Selection.Numbe rFormat = "[h]:mm:ss;@"
[/code]


REgards
Veena