Excel sees Jan-09 as January 9 of the current year.

Maybe you can save the field as a real date in an unabiguous format (January 7,
2008).

juliejg1 wrote:

I have an excel spreadsheet with a date field. The date currently shows
1/7/2008. I need all of the dates to show 2009, so I find and replace all
2008s with 2009. I then save the file as csv. When I reopen the file
everything seems fine until I change the date format to show Jan-09 and save
it again as csv. When the file is reopened again not only does the format
change (which isn't my concern) but the year goes back to 2008!!!

I've tried saving to text and then opening in excel but this doesn't make a
difference. Any suggestions or explanations as to why 2009 goes back to 2008?

--

Dave Peterson