Value of year changes to the current year when opening a csv file created in Excel

  • Like Christmas, this problem only comes by once a year.


    We have an Excel file that creates a journal entry in a csv file format that then gets imported into our accounting software. When creating journal entries for months in prior years, when we create the csv file and then import it into the accounting software, the value of the current year has replaced the value of the prior year. When we go into the actual csv file and manually correct the value of the year, save and close the file and then reopen it, the value of the year has again reverted to the value of the current year


    I have played with Excel's autocorrect settings (as I have found on various websites) with no success.


    Has anyone come across this problem and, more importantly, found an affective solution?


    Thx - Ray