Date Format Problem Importing CSV into OpenOffice
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Haven't Found your Answer?
It happens. Hit the "Login to Ask the community" button to create a question for the PayPal community.