Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
date formats when converting to office 2007
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERTING OFFICE 97-2003 EXCEL FILES TO 2007 EXCEL | Excel Discussion (Misc queries) | |||
Converting date formats | Excel Discussion (Misc queries) | |||
Date formats converting when docs sent to Japan | Excel Discussion (Misc queries) | |||
Help with converting date formats | Excel Worksheet Functions | |||
Converting date formats | Excel Discussion (Misc queries) |