How to Stop PDF to Excel Conversion from Changing Periods to Commas
Question details
The user needs to prevent decimal periods from being replaced by commas when converting PDF documents containing numerical data into Excel spreadsheets.

- Product
- Adobe Acrobat and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Converting a PDF with numerical data and decimal periods into an Excel spreadsheet.
- Observed behavior
- The exported numerical values have their decimal periods changed to commas, often due to conflicting regional or language settings.
Check your operating system's default regional settings, as PDF converters often rely on system-level formatting rules to interpret numbers.
Adjust Excel and System Regional Settings
Ensure your computer and Excel are set to a region that uses periods for decimals, such as the United States.
Many conversion tools inherit the default number formatting from your operating system or Excel. If your region defaults to a comma as a decimal separator (common in many European countries), the conversion will apply this rule.
Launch Microsoft Excel, click on 'File' in the top left corner, and select 'Options'.
Navigate to the 'Advanced' tab. Under 'Editing options', uncheck 'Use system separators', then manually set the Decimal separator to a period (.) and the Thousands separator to a comma (,). Click 'OK'.
Open the Windows Control Panel, go to 'Clock and Region', and select 'Region'. Click 'Additional settings' and verify that the 'Decimal symbol' is set to a period.

Configure Export Settings in Adobe Acrobat
Modify the document language and export options within Adobe Acrobat before starting the conversion.
Fix Separators Using Excel's Find and Replace
If the document is already converted, you can quickly replace the commas with periods directly within Excel.
Convert PDF to Excel Accurately with WPS Office
WPS Office offers a robust PDF to Excel conversion tool that intelligently recognizes table structures and preserves your original number formatting, saving you from manual adjustments.
- 1. Open PDF in WPS Office: Launch WPS Office and open the PDF file you wish to convert.
- 2. Select PDF to Excel: Navigate to the 'Tools' tab on the top ribbon and click on 'PDF to Excel'.
- 3. Start Conversion: Choose your desired output location and click 'Convert' to seamlessly generate an accurately formatted spreadsheet.

Frequently Asked Questions
Why do periods change to commas when exporting PDF to Excel?
This typically happens because the PDF converter or your operating system is using regional settings that default to a comma as the decimal separator, which is common in many European languages.
How do I change the default decimal separator in Excel?
Go to File > Options > Advanced. Under the 'Editing options' section, uncheck 'Use system separators' and manually type a period in the 'Decimal separator' box.
Does changing my Windows region settings affect other applications?
Yes, modifying your Windows regional settings will globally update how dates, times, and numbers are displayed across all supported applications on your computer.
Can I use WPS Office to convert PDFs without losing number formatting?
Yes, WPS Office includes a smart PDF to Excel converter that accurately detects numerical values and table structures, preserving your original decimal formatting during the export process.




