Connection: Excel 2007 - I have created a connection to copy a worksheet from another workbook. There are 2 date columns. When the dated is transferred to the current work book, one of the date columns is transferred in a "General" Format rather than the date format from which the original document is set up. I cannot reset the format back to "Date".
Any ideas of what I can do about this?

Hi,
I recommend that you attach your files, otherwise it will probably be difficult to help you out here.

Kind regards
Bjorn