Ok, work this one out.
I have a big routine that opens up an existing Excel workbook with several worksheets in it, and each tab represents different data, some are the results of a cross tab some from straight queries. I use mainly CopyFromRecordset and the range where the data is being copied has been pre formatted.
However on occasion I will copy a query containing currency data however when I view the workbook some of the cells are converted to dates and some remain as currency.
I have also coded a format as currency on the range but it still displays them as dates.