[RESOLVED] format excel cell for 2 decimal places

[wizkid]

I want to put some value in to my excel worksheet cell.
i want to format the cell to display only for 2 decimal places
for example

dim s as long
 
s=1.236767
.Cells(1, 4).Value = s

so i want the value for .Cells(1, 4).Value should be 1.23

how can i format this??i am using late binding
thanks
wizkid