Fonts & Office

Barcode Fonts for Excel & Word

Barcode fonts turn text into scannable symbols right inside your spreadsheet or document. Learn the Code 39 method, the critical start/stop rule, and where to get free fonts — plus when a generator is the safer choice.

Code 39 font simulator

See exactly what a Code 39 font produces — including the start/stop asterisks.

What the font must encode

*BARCODE*

The leading and trailing * are Code 39 start/stop characters — a font needs them or the symbol will not scan.

Excel formula

="*" & UPPER(A1) & "*"

Put your data in A1, apply this formula in B1, then set B1's font to a Code 39 font.

The concept

How barcode fonts work

A barcode font replaces ordinary letter glyphs with patterns of bars. Type a character and the font draws its barcode element instead of a letter. String enough characters together and you get a complete symbol — no graphics software required.

Code 39 is the easiest to use as a font because every character maps to a fixed, self-contained pattern. You only need to wrap the data in start/stop asterisks: *YOUR-DATA*.

Code 128, EAN and UPC are harder: they require computed check digits, guard patterns and (for Code 128) code-set switching. A plain font cannot do that maths, so those symbologies need an encoder add-in — or a dedicated generator like ours.

Code 39 in Excel — 5 steps

  1. 01

    Install the font

    Download a Code 39 TTF from a trusted source, right-click and Install (Windows) or double-click and Install Font (macOS). Restart Excel/Word.

  2. 02

    Prepare your data

    Put the raw value in A1. Code 39 uses uppercase letters, digits and - . $ / + % space.

  3. 03

    Add start/stop characters

    In B1 enter ="*" & UPPER(A1) & "*" so the value becomes *DATA*. Without the asterisks the symbol will not scan.

  4. 04

    Apply the font

    Select B1 and choose the Code 39 font. Increase the font size (e.g. 36–48pt) for a taller, more scannable symbol.

  5. 05

    Test-print & scan

    Print a sample and scan it with a phone or scanner. Keep white space around the code and avoid shrinking it.

Font vs Generator

Which should you use?

FeatureBarcode fontBarcodeForge generator
Setup effort Install font + formula None — type & download
Check digits Manual / add-in needed Computed automatically
Code 128 / EAN / UPC Requires encoder add-in Fully supported
QR & 2D codes Not possible Fully supported
Output formats Whatever the app prints PNG, SVG, JPG, PDF
Best for Quick internal Code 39 labels Retail, logistics & print-ready labels
Free downloads

Trusted free Code 39 fonts

Always download from the official source and check the license before commercial use. After installing, restart Office so the font appears in the list.

External links open in a new tab. BarcodeForge is not affiliated with these providers; fonts are subject to their own licenses.

Fonts FAQ

Frequently asked questions

What is a barcode font?

A barcode font is a typeface whose glyphs are bar patterns instead of letters. When you apply it to text, each character renders as part of a barcode. Code 39 fonts are the simplest because each character maps directly to a fixed pattern.

How do I use a Code 39 font in Excel?

Install a Code 39 font, put your data in a cell (e.g. A1), then in another cell use ="*" & UPPER(A1) & "*" to add the required start/stop asterisks, and set that cell's font to the Code 39 font. Increase the font size for a taller symbol.

Why does my Code 39 font barcode not scan?

The most common cause is missing start/stop asterisks (*) — the data must be wrapped as *DATA*. Also ensure the text is uppercase, the font size is large enough, and there is white space (quiet zone) around the symbol.

Can I use a font for Code 128 or EAN/UPC?

Not directly. Code 128 needs a computed checksum and code-set switching, and EAN/UPC need check digits and guard patterns — a plain font cannot calculate these. Use a font with a matching encoder add-in, or generate the symbol with our free generator instead.

Are barcode fonts better than a generator?

Fonts are convenient for quick internal Code 39 labels inside Excel or Word. For retail GTINs, Code 128, QR or print-ready output, a dedicated generator is more reliable because it computes check digits and renders to specification.

Where can I get a free Code 39 font?

Reputable free sources include IDAutomation's free Code 39 font and Grandzebu's Code 39 font. Always download fonts from the official site, install the TTF, and restart Office so the font appears in the font list.

Skip the font hassle

Generate Code 39, Code 128, EAN, UPC and QR codes with correct check digits and crisp export — no install, no formulas.