Each month the bank holding my credit card account provides a downloadable statement in CSV format. Each month I download the CSV file and covert it to a spreadsheet format using CALC. It quarter I consolidate the monthly files using “copy and paste” The worked well until July 2014. The dates in the bank file were in MM/DD/YYYY format and they later switched to YYYY/MM/DD format. Using CALC in Libre Office 4.4 (beta) to move from CSV to spreadsheet format I managed to convert the dates to MM/DD/YYYY and the year displayed as 2014. Eg., 11/15/2014. However, when performed the quarter consolidation the dates suddenly displayed as 2018. Eg., 11/15/22018. I have been unable to resolve this issue. All default beginning dates are set to 12/30/1899.
There may be something obvious I should change but I can’t find it. Help will be appreciated. I’m using a fresh copy of Win 8.1 home if that has some bearing on the problem. My computer is a new Samsung all in one.