Fix Barcode Fonts That Do Not Display Correctly in Excel
Question details
The user needs Excel to display barcode characters correctly in a workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or working with an Excel workbook that uses a barcode font.
- Observed behavior
- Barcode characters appear incorrectly or are unreadable when the required font is missing or unavailable.
Check which barcode font and barcode type the workbook uses. If the font is proprietary, contact its provider or the workbook creator for the correct installation package and instructions.
Install and reapply the required barcode font in Excel
Use this solution when the workbook's barcode font is missing or unavailable on the computer.
Select a barcode cell in Excel and check the font name on the Home tab. If the intended font is unclear, ask the workbook creator or barcode-font provider.
Obtain the font from its provider. On Windows, right-click the font file and select Install; on macOS, open the font file and select Install Font in Font Book.
Close and reopen Excel, select the barcode cells, and choose the installed font from the Home tab's font list.
Review the barcode cells and test a printed or displayed barcode with a scanner. If it does not scan, check the font provider's instructions for the required barcode encoding and formatting.

Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. It supports Excel files for easier migration, although the required barcode font must still be installed and the barcode data correctly encoded.

Frequently Asked Questions
Why do barcode cells show the wrong characters in Excel?
The required barcode font may be missing or unavailable. Select a barcode cell and check the font name on the Home tab, then install the correct font from its provider.
Why isn't my newly installed barcode font listed in Excel?
Close and reopen Excel, then check the font list on the Home tab. If the font is still missing, verify its installation in your operating system or follow the font provider's instructions.
Why does the barcode look correct but fail to scan?
The cell data may not use the encoding required by the barcode type, or the barcode may be too small or unclear. Check the font provider's encoding and formatting instructions, then test it with a scanner.
Will a barcode font travel with an Excel workbook?
Do not assume the workbook includes the font. The person opening it may need to install the same font on their computer, subject to the font provider's licensing terms.




