Fix Excel SUM Not Working After Acrobat PDF Conversion
Question details
The user needs Excel to calculate values converted from a PDF with Acrobat.

- 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.
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.
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.
In Excel, select the cells in the affected column, excluding the header.
If a warning icon appears beside the selection, click it and choose Convert to Number.
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.
Enter or recheck a formula such as =SUM(A2:A20), using the range containing your converted values.

Clean hidden characters before converting the values
Use a helper column when hidden spaces or currency symbols prevent Excel from recognizing the imported values.
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. Open the workbook: Open WPS Spreadsheets and choose Open to select the workbook exported from Acrobat.
- 2. Select the imported values: Select the cells containing the values you want to add, without including the column header.
- 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. 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.

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.




