date format importing to Cashbook
I am using an old version of Quicken Cashbooks and frustrated trying to import QIF files from my bank as it always imports the year as '20'. I think this is a limitation of the old software which only offers an import date format of DDMMYY or MMDDYY so I think it reads just the first 2 characters of '2017'. I have tried to find a way of editing this in Excel but the date format there can only be saved as ddmmyyyy (yes, I can change the way it displays in Excel but not the underlying date format.) Any suggestions would be REALLLLY welcome!