Date Format Problem Importing CSV into OpenOffice

PepperMill
Contributor
Contributor

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!

Login to Me Too
1 REPLY 1

snowshoe
Frequent Advisor
Frequent Advisor

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.

Login to Me Too

Haven't Found your Answer?

It happens. Hit the "Login to Ask the community" button to create a question for the PayPal community.