You installed a barcode font, typed a product number into Excel, switched the cell to the font, and got bars that look exactly like a barcode. The scanner stays silent. The scanner is almost never the problem: a barcode font draws characters as bars, but a scannable barcode needs more than the characters. This article explains what is missing, how to check your own sheet, and how to fix it, with or without BarcodePop.
A font only changes how characters look #
A barcode font maps each character to a pattern of bars, the way any font maps characters to letter shapes. What it cannot do is add anything that is not in the cell. A scanner, though, expects a complete symbol: special patterns at both ends, a check character in many types, and white space around it. If the cell holds only your number, the font draws only your number.
1. Start and stop characters #
Every 1D barcode begins and ends with a start and a stop pattern. They tell the scanner where the barcode begins, where it ends and in which direction it is read. Without them a scanner does not recognise the bars as a barcode at all.
- Code 39 uses the asterisk as start and stop character. With a Code 39 font you have to type
*ABC123*, or use a formula such as="*"&A2&"*". This is why Code 39 is the one font that sometimes “just works”: people add the asterisks without knowing why. - Code 128 has three different start characters (for code sets A, B and C) and a stop character. Which start character is right depends on the content, and the font cannot choose it.
- EAN-13 and UPC-A have guard bars at both ends and in the middle, and the left half of the number is encoded differently from the right half, depending on the first digit. A plain font cannot do that from a string of digits.
2. Check characters and check digits #
Most barcode types carry a check value that the scanner recalculates to catch misreads. If it does not match, a well-configured scanner rejects the read.
- Code 128 needs a mod 103 check character, calculated from every character and its position. It has to be computed and placed before the stop character, and then mapped to the right glyph of the font. A typed value never has it.
- EAN-13, UPC-A, EAN-8 and ITF-14 end with a check digit (mod 10). If your numbers already have it, the font draws it like any digit; if one is wrong or missing, the barcode scans as an error or as a different number.
That is why Code 128 and EAN fonts come with an encoder: a set of formulas, a VBA macro or a separate tool that turns ABC123 into a string of odd-looking characters, which the font then draws correctly. Without the encoder the bars look right and do not scan.
3. Numbers that changed before the font saw them #
Excel stores numbers as numbers, so the value can change before any font draws it:
- A UPC such as 012345678905 loses its leading zero and becomes 12345678905, one digit short.
- A number with more than 15 digits is rounded: Excel keeps 15 significant digits and fills the rest with zeros.
- A long number may be shown as 1.23457E+12, and the font then draws exactly that text.
See Leading zeros or scientific notation for how to keep numbers intact.
4. Quiet zones and size #
A scanner needs a white margin on both sides of the bars, the quiet zone: ten times the narrowest bar for Code 128, eleven on the left of an EAN-13. In a cell, the barcode often touches the cell border, the next column’s text or a fill colour. Size matters too: a font scales with the font size, so a small font size or a printout scaled to fit the page gives bars thinner than many scanners resolve, and bar widths that do not land on whole printer dots print unevenly.
5. The font does not travel with the file #
A font is installed on one computer, not stored in the workbook. When a colleague, a customer or a print shop opens the file without that font, Excel shows the plain characters (or the encoded gibberish) instead of bars. Installing a font usually needs admin rights on company computers, has to be repeated on every Windows and Mac computer that opens the file, and Excel on the web cannot use a font installed on your computer at all.
How to tell what is wrong with your barcode #
- Scan the barcode with a phone app that shows the barcode type and the data. If nothing is read, start and stop or check characters are missing (points 1 and 2). If the wrong number is read, look at point 3.
- Look at the cell’s value (not the shown text) in the formula bar. If it does not have asterisks for Code 39, or does not look encoded for Code 128, the encoding step is missing.
- Open the file on another computer or in Excel on the web. If you see digits instead of bars, the font is not there (point 5).
If you want to keep the font #
It can work. Use Code 39 with the asterisks around every value, or use the encoder that came with your Code 128 or EAN font for every cell; keep long numbers as text; leave empty cells around the barcode; print at 100%; and install the font on every computer that opens or prints the file. For files that leave your computer, export a PDF so the font goes with it.
The fix without a font: barcode pictures #
BarcodePop takes the other route. It draws each barcode as a picture, with the start, stop and check characters already in it, and places the picture next to the value in your sheet:
| Problem | Barcode font | BarcodePop |
|---|---|---|
| Start and stop characters | You add them, or an encoder does | Drawn in |
| Check characters | Computed by a formula or a macro | Computed for Code 128; checked for EAN, UPC and ITF-14, with a skipped row and the right digit when one is wrong |
| Leading zeros, rounded numbers | Not noticed | Lost zeros added back, rounded numbers skipped with the reason |
| Quiet zones and bar widths | Depend on the cell and the font size | White margins inside the picture, every bar on whole pixels |
| Other computers and Excel on the web | Font needed on every computer | Pictures in the workbook, nothing to install |
The free version makes up to 50 barcodes per workbook in every 1D type, including Code 128, EAN-13 and UPC-A. Create barcodes from a list shows the steps.
