Format Excel Cells to Number

[DMT Dave]

Hi Guy's this should be quite simple but unsure where i am wrong, i am trying to format specific cells in Excel as a number

The recordset output is set to long integer but when the excel file is created, it comes out as a date 01/01/1900

I have tried this but debugs

.Worksheets(1).Range("C3:C50").NumberFormat = "Number"



Kind Regards

[June7]

Try:

.Worksheets(1).Range("C3:C50").NumberFormat = "0.00"

or

.Worksheets(1).Range("C3:C50").NumberFormat = "General"

I use macro recorder to get these.