Date Format Problem Importing CSV into OpenOffice

[PepperMill]

When I download CSV transactions and import into OPenOffice Calc (I don't have MS Excel), the date is in the format of M/D/YYYY if the da or month is less than 10. This makes it impossible to sort properly.

I don't want to go through each and every of the thousands of transactions to fix the format. I tried a search and replace and it doesn't work properly.

Is there any way to change the format of the date downloaded to be in the YYYY/MM/DD format?

Does anyone know of another solution?

Thanks!

[snowshoe]

Suggest that you contact Tech Support to find out there's a work around for your issue:

https://ppmts.custhelp.com/app/home

Note, you need to setup an account first, then you can submit and track your question.