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.
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.
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.
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.
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
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.
- How to Generate Barcode Numbers in Excel
- How to Convert Numbers to Barcode in Excel
- How to Generate 2D Barcode in Excel
- How to Create Barcode Without Font in Excel
- How to Use EAN 13 Barcode Generator in Excel
- How to Create Barcode Using 3 of 9 Font in Excel
- How to Calculate Barcode Check Digit with Excel Formula
- How to Add Barcode Font in Excel