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