In comparison with Code 39, the barcodes of Code 128 are denser and are usually used for container and pallet levels in the supply chain. Code 128: It is generally used for shipping and supply chain labels.If you’re the curious type, here is some more information on different types of barcodes.
You can also install and use other barcodes in Excel similar to Code 39. That’s why it got the name 39.Īpart from this type, you probably heard of other barcodes, such as Code 128 (similar to 39, usually used for shipping), or UPC/EAN (used for product barcodes). This type displays each character as five bars and four spaces, while three bars are wider than the others. Different Types of BarcodesĬode 39 is one of the easiest barcode font to use and includes both numbers and letters. It would also work on other office applications such as MS Word and MS PowerPoint.
Note that when you install the font on your system, it doesn’t work just in Excel. In case you don’t want this, you can convert the formula in column B to values. In our example, the barcode in column B is dynamic, which means that if the value in column A changes, the barcode would automatically update.
Converting Cell Format to Textīefore I show you how to convert numbers or alphanumeric characters into barcode, you need to know an important thing. Now that the barcode font is installed on your system, let’s see how to use it to create barcodes in Excel. And three of these nine bars would have more width, hence the 3 in 39. If you’re wondering why this is called Code39, that’s because it generates a barcode that has five bars and four spaces (so a total of 9). In case you already have a file open, you should save and then reopen it to be able to see it in the barcode font. Now, the font is installed on your computer and you can use it in applications such as MS Excel. This will install the font on your system
TTF file (when you open a file, you can see the preview of the font)