excel cell formating 1

[lchase]

I am filling excel from an access query. in the QBE there is a field called Weight it has 2 decimal places(all with zeros). I can't seem to format the cells containing this data (column J in Excel)I would like two decimal places but am getting 0. Here is what I've tried the 1,2 and 3 are just for reference
With xlSheet.Rows(lngRecordNumber)
.Cells(, hctr).Value = rstQuarterSales(hctr )'recordset
(1).Cells(, hctr) = Format( .Cells(, hctr) ,"###0.00&quot
(2).Cells(, hctr) = Format( .Cells(, hctr) ,"Fixed&quot
(3).Cells(, hctr) = Formatnumber( .Cells(, hctr), 2)
Any Help is appreciated.
Len

 

[rmikesmith]

Len,

Try

.Cells(, hctr).NumberFormat = "###0.00"[code]

Format codes are the same as those used when you select Format/Cells... from the menu.


HTH
Mike

 

[lchase]

I tried that and it did the trick thanks.
Len