How to Use Code 39 Barcode Font for Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates how to use the code 39 barcode font for excel. Barcodes are extensively used worldwide and have a wide range of applications. For example, a barcode can be generated for the price of a grocery product. Now if the barcode is printed on the packet of the product, then the store employee can use a barcode scanner to prepare the bill quickly because she doesn’t have to type the price value. You can use the code 39 barcode font to generate barcodes in excel. Follow the article to learn how to do that.

You can download the code 39 barcode font from here.


Download Practice Workbook


Steps to Use Code 39 Barcode Font for Excel

Follow the steps below to generate barcodes using the code 39 barcode font for excel.

📌 Step 1: Download a Suitable Code 39 Barcode Font

  • First, close all of your office applications. Then download the code 39 barcode font using the download link above. Next, open the downloaded zip file.


📌 Step 2: Install the Code 39 Barcode Font

  • Then, open the file with the .ttf extension.

  • Next, click on Install to install the font.

code 39 barcode font


📌 Step 3: Apply the Code 39 Barcode Font

  • Now open Excel and select the cell or range from which you want to create the barcode. Then type Libre Barcode 39 as the font type. Alternatively, you can scroll down and select that.

  • After that, the barcode will be generated. Next, change the font size and adjust the row and column heights. But, you won’t be able to read these barcodes using a barcode reader/scanner because the barcode reader won’t be able to detect the starting and ending points.

code 39 barcode font


📌 Step 4: Format Dataset for Scannable Barcode

  • Now enter the following formula in cell C5 to fix this issue. Then drag the fill handle icon to copy the formula to the cells below. After that, you will get the following result. The asterisks (*) define the starting and ending points for the barcode reader to read the code.
="*"&B5&"*"


📌 Step 5: Generate Machine-Readable Barcodes

  • Then, select the range C5:C10 instead and apply the Libre Barcode 39 font. After that, you can read the barcodes using a barcode scanner.

code 39 barcode font

Read More: How to Generate Code 128 Barcode Font for Excel (With Easy Steps)


Things to Remember

  • Don’t forget to use asterisks (*) before and after the text/number from which you want to generate the barcode. Otherwise, you won’t be able to read the barcode using a reader.
  • You can download and install any other code 39 barcode font (ID Automation Code 39 Barcode Font) with premium features for a better experience. In that case, you need to apply that particular font type instead.
  • You can print the sheet to check if the barcodes work.

Conclusion

Now you know how to use the code 39 barcode font in excel to generate readable barcodes. Do you have any further queries or suggestions? Please let us know using the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza
Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo