PDF Conversion Issues

How to Stop PDF to Excel Conversion from Changing Periods to Commas

Huda QurayshiHuda Qurayshi Oct 22, 2026 870 views

Question details

The user needs to prevent decimal periods from being replaced by commas when converting PDF documents containing numerical data into Excel spreadsheets.

How to Stop PDF to Excel Conversion from Changing Periods to Commas
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.
Before you start

Check your operating system's default regional settings, as PDF converters often rely on system-level formatting rules to interpret numbers.

Solution 1Recommended

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.

1
Open Excel Options

Launch Microsoft Excel, click on 'File' in the top left corner, and select 'Options'.

2
Modify Advanced Settings

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'.

3
Change Windows Region Settings

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.

Adjust Excel and System Regional Settings
Seamless PDF Conversion

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. 1. Open PDF in WPS Office: Launch WPS Office and open the PDF file you wish to convert.
  2. 2. Select PDF to Excel: Navigate to the 'Tools' tab on the top ribbon and click on 'PDF to Excel'.
  3. 3. Start Conversion: Choose your desired output location and click 'Convert' to seamlessly generate an accurately formatted spreadsheet.
Accurately retains original number formats and decimal separatorsFully compatible with Microsoft Excel (.xlsx) formatsSmart table recognition to minimize manual cleanupFree, lightweight, and user-friendly interface
microsoft office alternative - wps office

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.