S
Sheldon
I use excel quite a bit for work. On sevarl sheets, I have inserted a
calendar control in each one so I could easily click on the date and evaluate
data from that date. After I click on the calendar it will allow excel to
pull data from other places correctly (corresponding to that date). 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.
calendar control in each one so I could easily click on the date and evaluate
data from that date. After I click on the calendar it will allow excel to
pull data from other places correctly (corresponding to that date). 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.