How to Create Barcode Using 3 of 9 Font in Excel

Get FREE Advanced Excel Exercises with Solutions!

Barcodes are Some consecutive lines and spaces together which represent machine readable information. Barcodes are widely used for many applications like representing the information of grocery products or encoding confidential information. 3 of 9 or code 39 is a barcode type in Excel. In this article, we will discuss the procedures to make 3 of 9 barcode in Excel.


About 3 of 9 Barcode Font in Excel

Barcode uses lines and spaces to represent information. Excel doesn’t include any barcodes fonts by default. But we can install barcode fonts and use it to create barcodes in Excel. 3 of 9 is one type of font in Excel which is used to create barcodes. Using the 3 of 9 barcode font we can create barcodes for all capital letters, numeric values, and a few symbols like (&), (%), (/), (.), etc. The barcode is formed with 5 bars and 4 spaces to represent 1 character.

Read More: How to Add Barcode Font in Excel 


Download and Install font

We can download and install the font in Excel by following the steps below.

Step 1: In order to create the 3 of 9 barcode in Excel we need to download 3 of 9 barcode fonts first.

3 of 9 barcode excel

Step 2: Then we need to extract the file and install the True Type font file. You might have seen the following type of window in front of you.

Step 3: Now we check if the font is included in the font box in the Home tab. If not found we need to restart Excel and try again.

3 of 9 font installed in excel

We can see the 3 of 9 Barcode font is installed.

Read More: How to Use Code 39 Barcode Font for Excel


How to Create Barcode Using 3 of 9 Font in Excel

The inputs for barcodes can be numeric values or text values. Here we will discuss the procedure to create 3 of 9 barcode in Excel stepwise. We will take numeric values as well as text values as input for the barcode.


1. Barcode from Numeric Input

Now we need to create a dataset where we will create the barcode. Here we will show the steps for barcodes of numeric input values.


Creating the Dataset

The steps to create a dataset for numeric input are given below.

Step 1: At first we have to create a table that will include one column for the numeric inputs and one for barcode outputs.

3 of 9 barcode dataset

Step 2: Then we have to select the input cells which contain the numeric value.

Step 3: Then we have to change the Number Format from the Home tab in the ribbon into Text type. By default, it was General type.

Step 4: Now we have to select the cell where we want the barcode and write the following formula there.

="("&B6&")"

Here, the formula creates the format for the barcode and B6 is the cell for input.

3 of 9 barcode for numeric

Step 5: We have to use Fill Handle to copy the formula for the cells below.

Now we are ready to create the barcodes.


Applying the Font

We are almost done. We have to follow the steps below to create the barcode.

Step 1: We have to select the cells for output first.

Step 2: Now we select the 3 of 9 Barcode from the Font box in the ribbon of the Home tab.

We will see the 3 of 9 barcodes for the inputs like the table below.

3 of 9 barcode result

Read More: How to Generate Code 128 Barcode Font for Excel


2. Barcode from Text Input

If the input is a text value instead of a numeric value then we can create the barcode in a similar but slightly different way. The steps are discussed below.


Creating the Dataset

The steps to create a dataset for text inputs are given below.

Step 1: We need to create a table which includes one column for the text input and one column for barcode output.

3 of 9 barcode text input

Step 2: Now we will select the cell where we want to see the output barcode and write the following formula there.

="("&B6&")"

Here, the formula creates the format for the barcode and B6 is the cell for input.

Step 3: We use Fill Handle to copy the formula to the cells below.


Applying the Font

We are ready to create the 3 of 9 Barcode for text input. The steps of the procedure are given below.

Step 1: We have to select the cells for output first.

Step 2: Now we need to go to the Font box in the ribbon of the Home tab. We have to select 3 of 9 Barcode from the list.

We will see the barcodes for the text inputs just like below.

3 of 9 barcode excel text result

Hurrah! We have done the job. We can see the barcodes for the input.

Read More: How to Create Barcode Without Font in Excel 


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Barcode is a very essential tool which helps to store information in a secure way. Though Excel doesn’t include any barcode font by default, we can easily install the font and use it. In this article, we have shown the procedure to create 3 of 9 Barcode in Excel. If you face any problem following the steps or if you have any suggestions for our article, please let us know by comment.


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.
Mehedi Hasan Shimul
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo