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.


Step 1: Downloading 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.

Read More: How to Create Barcode in Excel


Step 2: Installing 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: Applying the Code 39 Barcode Font in Excel

  • 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: Formatting 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: Generating Machine-Readable Barcodes in Excel

  • 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


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.

Download Practice Workbook


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. Stay with us and keep learning.


Related Articles


<< Go Back to Barcode in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo