Hi Larry,

I think the problem is caused by having the Format Cells Category in Excel set to general instead of date. Click on the Column heading in Excel and see what the Format Cells Category is set to.

Hope this helps,

Gavin...

>Hello All,
>
>I'm trying to populate a date field in a table with a date from an Excel file. The date looks ok in the Excel file, but when I put it in a varaiable using the following code:
>
>.Range("C6").Select
>temp= ALLTRIM(.ActiveCell.FormulaR1C1)
>
>I get a 5 character number like 36841. Any ideas to help would be greatly appreciated.
>
>Thanks