Function Problems

Fix Excel SUM Not Working After Acrobat PDF Conversion

John WilsonJohn Wilson Nov 19, 2026 870 views

Question details

The user needs Excel to calculate values converted from a PDF with Acrobat.

Fix Excel SUM Not Working After Acrobat PDF Conversion
Product
Microsoft Excel and Adobe Acrobat
Device & OS
not provided
Scenario
A PDF table was converted to an Excel worksheet, and the user wants to total a column with SUM.
Observed behavior
The converted values behave like text, and SUM does not calculate them correctly, even after the column is copied to a new workbook.
Before you start

Check whether the affected cells show a number-stored-as-text warning or contain visible currency symbols and spaces. Confirm that decimal and thousands separators match your Excel regional settings before converting the values.

Solution 1Recommended

Convert the imported Excel column to numbers

Use Excel's built-in conversion tools when the PDF values are stored as text but otherwise look like valid numbers.

1
Select the values

In Excel, select the cells in the affected column, excluding the header.

2
Use the warning button

If a warning icon appears beside the selection, click it and choose Convert to Number.

3
Try Text to Columns

If no warning appears, keep the cells selected and choose Data > Text to Columns. Click Next twice, select General, and click Finish. Use Advanced in the wizard if you need to specify decimal or thousands separators.

4
Check the total

Enter or recheck a formula such as =SUM(A2:A20), using the range containing your converted values.

Convert the imported Excel column to numbers
Formatting alone does not convert text: Applying Number format changes how numeric cells appear, but it does not turn text into numbers. Clean remaining symbols or hidden spaces if the conversion fails.
Work with converted tables in WPS

Convert PDF table values to numbers in WPS Spreadsheets

Open the converted workbook in WPS Spreadsheets, convert text-formatted values, and use SUM to check the resulting column total.

  1. 1. Open the workbook: Open WPS Spreadsheets and choose Open to select the workbook exported from Acrobat.
  2. 2. Select the imported values: Select the cells containing the values you want to add, without including the column header.
  3. 3. Convert the column: Choose Data > Text to Columns, proceed through the wizard with General selected, and click Finish. If values still remain as text, inspect them for extra symbols or spaces.
  4. 4. Calculate and save: Enter a formula such as =SUM(A2:A20) in an empty cell, check the result, and use File > Save As to save the workbook in XLSX format.
Convert imported text values and total them with SUMOpen and save Microsoft Excel XLSX workbooksUse familiar spreadsheet formulas and menusWork with spreadsheets in the free WPS Office suite
QA img-9

Frequently Asked Questions

Why does SUM ignore values copied from a converted PDF?

The values may be stored as text or contain hidden spaces or symbols. Select the cells and use the warning icon's Convert to Number option or Data > Text to Columns.

Why didn't copying the column to a new workbook fix it?

Copying can preserve text values and hidden characters. Convert or clean the copied cells rather than relying on the new workbook to change their data type.

Will changing the cell format to Number fix SUM?

Not if the values are still text. First convert them using Convert to Number, Text to Columns, or VALUE; then apply Number format from the Home tab if desired.

What if SUM still doesn't update after conversion?

Check that the formula references the correct cells and that the converted cells are numeric. In Excel, also check Formulas > Calculation Options and select Automatic.