Formatting Issues

Fix Barcode Fonts That Do Not Display Correctly in Excel

Phi Hung VoPhi Hung Vo Nov 13, 2026 871 views

Question details

The user needs Excel to display barcode characters correctly in a workbook.

Fix Barcode Fonts That Do Not Display Correctly in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Identify the font

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.

2
Install the correct font

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.

3
Restart Excel and apply the font

Close and reopen Excel, select the barcode cells, and choose the installed font from the Home tab's font list.

4
Check the barcode

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.

Install and reapply the required barcode font in Excel
Third-party font support: Some barcode fonts require a license, specific encoding, or additional software. Contact the font provider if installation or scanning still fails.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for everyday editingWork with barcode cells when the required font is installedMove existing spreadsheets into a free, lightweight office suite
microsoft office alternative - wps office

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.