PDF Conversion Issues

How to Fix Numbers Turning into Boxes in Combined PDFs

Anum MushtaqAnum Mushtaq Nov 10, 2026 870 views

Question details

The user needs to resolve an issue where numbers in an Excel-generated PDF appear as square boxes after being combined with another PDF document.

How to Fix Numbers Turning into Boxes in Combined PDFs
Product
PDF
Device & OS
not provided
Scenario
Combining an Excel-created PDF with another PDF document.
Observed behavior
Numbers display as square boxes instead of the correct characters after the PDFs are merged.
Before you start

Ensure you have access to the original Excel file used to create the PDF, as the most effective fix involves correcting the font settings during the initial export.

Solution 1Recommended

Verify and Embed Missing Fonts in the PDF Viewer

Check if the fonts are properly embedded in your document to prevent text from rendering as boxes.

When a PDF relies on a font that is neither embedded in the document nor installed on the viewing device, the system substitutes the missing characters with square boxes. Checking the document properties will confirm if this is the cause.

1
Open Document Properties

Open your PDF in Adobe Acrobat, navigate to the "File" menu, and select "Properties".

2
Check the Fonts Tab

Click on the "Fonts" tab. Review the list of fonts used in the document and look for "(Embedded)" or "(Embedded Subset)" next to the font names.

3
Embed or Replace Fonts

If fonts are missing, recreate the PDF from the original Excel file, ensuring you select the option to embed all fonts in the export or print settings.

Verify and Embed Missing Fonts in the PDF Viewer
Font Licensing Restrictions: Some custom fonts have licensing restrictions that prevent them from being embedded. Using standard system fonts like Arial or Calibri can bypass this issue entirely.
Combine PDFs Seamlessly with WPS Office

Use WPS Office to Merge PDFs without Font Errors

WPS Office provides a robust PDF toolkit that perfectly preserves fonts, formatting, and numbers when converting from Excel or combining multiple PDF documents.

  1. 1. Open WPS PDF: Launch WPS Office and click on "PDF Edit" to open the PDF toolkit.
  2. 2. Select Merge PDF: Click on "Merge PDF" from the tool menu and add the PDF files you want to combine.
  3. 3. Output the Merged File: Adjust the order of your documents if necessary, then click "Merge" to create a single, perfectly formatted PDF document without missing font errors.
Accurately preserves numbers and text formatting during PDF creation and merging.Fully compatible with Microsoft Excel (.xlsx) and standard PDF formats.Built-in PDF editor to easily manage, combine, and edit PDF files.Free, lightweight, and easy to use on Windows, Mac, and mobile.
microsoft office alternative - wps office

Frequently Asked Questions

Why do numbers turn into boxes in my PDF?

This happens when the PDF reader cannot find the specific font used for the numbers. If the font wasn't embedded when the PDF was created and isn't installed on the current device, the system substitutes the missing characters with square boxes.

How do I make sure fonts are embedded when saving as a PDF in Excel?

When saving as a PDF in Excel, go to "Options" in the Save As dialog box and ensure "ISO 19005-1 compliant (PDF/A)" is checked, as this archival format strictly requires all fonts to be embedded.

Can I fix the boxes without the original Excel file?

If you don't have the original file, you can try using the "Edit Text" feature in a premium PDF editor to select the boxes and change their font to a standard system font like Arial, provided the underlying character data is still intact.