I have spreadsheet developed in Excel 2003 inserted a calendar control in a
spreadsheet so I could easily click on the date and evaluate data from that
date. After I click on the calendar it will poplulate a series of cells and
allow excel to pull data from other places correctly. However, after I
upgraded to excel 2007, the format of this date is not read in my graphs
correctly. On the graphs it is showing up as a 1900 date. I can reformat
the cells (paste special and reformat) and get it to display correctly, but
everytime I click on my calendar control, it reverts back to the other
"incorrect" format. It used to work fine in Office 2003.

I believe it is two quirks. The format of the date shows fine in the cells,
but the graphs will not show it correctly. The other problem is that the
calendar control overwrites any format I have for a cell.

Please help. I can't find any solutions to this quirk. I can send you a
copy of the file if that would help. Thanks.