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?