Hi,
I am making a graph with dates along the X-axis. The data was exported from
Access and is in the format m/dd/yyyy h:mm:ss AM/PM. Excell doesnt seem to
recognize this as a data format and it wont graph properly. I have tried
"format cells", but it doesnt work. What is really strange is that when I
click in the cell and then press enter, it converts to a date format that is
recognized by excell. I have over 2 years of hourly data, so I dont really
want to click in every cell. Anyone have any suggestions?