date format importing to Cashbook

  • 1
  • Question
  • Updated 8 months ago
  • Answered
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!
Photo of Martin Le Grice

Martin Le Grice

  • 130 Points 100 badge 2x thumb

Posted 8 months ago

  • 1
Photo of Shane

Shane, Employee

  • 7,378 Points 5k badge 2x thumb
Hi Martin,

Use notepad to edit it instead of Excel.  Then make the date ddmmyy and try importing.  In notepad you can do whatever you want.

Regards,
Shane.
Photo of Martin Le Grice

Martin Le Grice

  • 130 Points 100 badge 2x thumb
Many thanks Shane - that's a great suggestion for editing - but I still have the problem of importing. I need to convert from a csv file to  qif, and if I paste back from notepad into csv it reverts to date format!! Unless you know a way of importing from notepad do you??