Fix PDF to Excel Converting Dates to Wrong Regional Format
Question details
Users need to correct the date format in Excel after converting a PDF, as the converter incorrectly applies the US date format instead of the local region format.
- Product
- Adobe Acrobat, Microsoft Excel
- Device & OS
- Windows
- Scenario
- Converting a PDF document containing dates to an editable Excel spreadsheet.
- Observed behavior
- The conversion changes local date formats like Australian DD/MM/YYYY to the US format MM/DD/YYYY, ignoring the correct Windows regional settings.
Ensure that your Windows regional settings are correctly configured for your locale (e.g., English - Australia) and verify whether the original PDF dates are selectable text rather than images.
Reformat Dates Using Excel Text to Columns
Force Excel to properly parse the misconfigured dates using the Text to Columns feature, and verify if the issue is a systemic converter bug.
When Acrobat or other converters export dates to Excel, they may be pasted as text or miscalculated serial numbers. You can manually adjust the locale formatting in Excel. If the issue happens consistently across the Acrobat desktop app and the web add-on, it is likely a cloud conversion bug.
Click on the affected date cells in Excel and look at the formula bar to see if the date was exported as plain text or as a swapped date serial value.
Highlight the column with the incorrect dates, navigate to the 'Data' tab, and click 'Text to Columns'. Click 'Next' twice.
In Step 3 of the wizard, select 'Date' under Column data format, choose 'DMY' (Day, Month, Year) from the dropdown, and click 'Finish'.
Right-click the corrected cells, choose 'Format Cells', go to the 'Number' tab, select 'Date', and ensure the Locale is set to your specific region (e.g., English (Australia)).
If the dates are still converting incorrectly regardless of your Windows settings, test the PDF using the Acrobat browser add-on. If both fail, report the bug with sample files to Adobe Support.
Convert PDFs to Excel Accurately with WPS Office
Avoid frustrating regional date format bugs by using the WPS Office built-in PDF to Excel converter. It accurately extracts tabular data while respecting your local formatting.
- 1. Open your PDF in WPS: Launch WPS Office and open the PDF file containing the data you need to convert.
- 2. Access the conversion tool: Navigate to the 'Tools' tab at the top and select 'PDF to Excel'.
- 3. Configure conversion settings: Choose the pages you want to convert, ensure the language and output format (.xlsx) are correct, and click 'Convert'.
- 4. Review the data: Open the converted document in WPS Spreadsheet to verify that your DD/MM/YYYY dates are perfectly preserved.
Frequently Asked Questions
Why does my PDF to Excel conversion swap days and months?
This happens when the PDF conversion engine defaults to the US date standard (MM/DD/YYYY). If the cloud server or software doesn't inherit your system's regional settings, it will misinterpret dates like 12/05/2023 as December 5th instead of May 12th.
Does changing Windows region settings fix Acrobat conversion bugs?
Not always. If the software uses a cloud-based conversion service, the conversion happens on remote servers that might default to US date formats regardless of your local Windows Control Panel settings.
How can I quickly fix inverted dates in my entire Excel sheet?
The fastest method is to highlight the affected column, click 'Data' > 'Text to Columns', skip to the third step of the wizard, select 'Date', and choose 'DMY' from the dropdown menu to force Excel to read it as Day-Month-Year.
