Convert to Excel incorrect region format for date
- February 9, 2025
- 1 reply
- 794 views
I have a PDF report that has a column of dates with the text formatted as DD/MM/YYYY for the Australian region. Last year up to Decemeber 2024 I was able successfully convert the PDF files to Excel using Acrobat and the Excel cells with a date were correctly interpreted as DD/MM/YYYY. I have started doing the conversion this year and the dates are being converted as if they are in MM/DD/YYYY formatted. I have tried this on multiple Windows 11 computers which have the correct region settings. I have use the Acrobat desktop app on Windows as well as Acrobat add-on for Microsoft Edge. I have been able to recreate the issue with a PDF I created myself. I have attached the PDF and the resulting Excel file. You will see the Excel file displays DD/MM/YYYY but when you click on the cell you see the value is MM/DD/YYYY. If you apply the General format, you see the date number value whihc reflect the USA date. Hope I fhave explained this well.
