I have a excel sheet excel ver 2007 that I type in a date and the date shown in an included chart shows an incorrect year. My dates are daily once that are from year 2006 to the present day but the access at the bottom of the chart shows years 1900 through 1904. This is the only place where the dates are wrong. What can cause this?
I've tried formating the date for the access to several types and they all show these years. hmmm. It's like Y2k happened here
I've tried formating the date for the access to several types and they all show these years. hmmm. It's like Y2k happened here