How to Fix Numbers Turning into Boxes in Combined PDFs
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.

- Product
- 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.
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.
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.
Open your PDF in Adobe Acrobat, navigate to the "File" menu, and select "Properties".
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.
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.

Re-export the PDF from Excel with Standard Fonts
Re-exporting the file with universally supported fonts avoids embedding errors during PDF merging.
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. Open WPS PDF: Launch WPS Office and click on "PDF Edit" to open the PDF toolkit.
- 2. Select Merge PDF: Click on "Merge PDF" from the tool menu and add the PDF files you want to combine.
- 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.

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.




