I have an Excel file that I use constantly. I store it in XLStart and it not only contains personal macros but also many sheets with data that I frequently access. One such sheet tracks the stock market and whenever I copy/paste currency (or any) information from the internet, it appears in the file as a date. When I copy the same data to a different file is appears as currency.

I have tried numerous approaches to find or correct the problem but it never goes away. Also it seem that whenever there is a Microsoft hiccup, all the cells on all the sheets in the file change to the date format. This happen frequently enough that I have written several macros to help with the recover.

Any suggestions as to why this is occurring or how I can correct it would be greatly appreciated.

Thanks