I 'THINK' that when you import the csv file to Excel, Excel sees 'Jan-09' and
interprets that as January 09, 2008 (2008 being the current year).
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"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?