How to Convert Numbers to Barcode in Excel (3 Easy Ways)

A barcode is a machine-readable code consisting of numbers and a pattern of parallel lines and is used for warehouse management. Barcode numbers, which can be created in Excel, are used by everyone from small merchants to large corporations. To make our lives simpler, we sometimes want to create barcodes in Excel. In this article, you will find detailed instructions on how to convert numbers to barcode in Excel.

We may produce Barcode Numbers in Excel by following a few steps. We have a dataset with the Product and its corresponding Code. We will now demonstrate how to produce barcodes from the provided codes.

1. Converting Numbers to Barcode Using Barcode Font in Excel

We will convert Numbers to Text by using the Format Cells feature. This is required for the proper presentation of any type of Code. Afterward, we will add Barcode font in Excel and then convert the number into Barcode.

📌 Steps:

Firstly, right-click and choose Cell range C5:C11. Next, choose Format Cells.

Afterwards, go to Format Cells >> Number tab >> Text option >> press OK.

Suppose, we prefer Code and Barcode in two different columns. To accomplish that, in cell D5 of the Barcode column, we will enter the following formula.

=C5

Now, drag down the fill handle to fill up the rest of the cells.

From any website, we’ll get the font “Barcode” (just search with download barcode font).
You will get the Downloaded file in a zipped format.
Firstly, unzip the downloaded file >> double click on the BarcodeFont >> barcode font (True Type) window will appear >> next, click on Install.

Now, we have installed the barcode fonts successfully.

Now, choose the cell range D5:D11. Then, go to the Home tab and choose the Barcode Font from the drop-down list.

Eventually, you will receive the Barcode Numbers for your Products in Excel.

2. Using Code39 Font to Convert Numbers to Barcode

Now we will go through how to make a barcode in Excel using the “Code39” font and a few numbers to convert into a barcode. Code39 font is one of the most used fonts for labels such as inventories, badges, and industrial applications.

📌 Steps:

From a trustable website, you can download the font “Code39“.
Now, the downloaded file will be zipped. Firstly, unzip the downloaded file >> double-click on the Code39r.
Code39 Regular (True Type) window will appear.
Next, click on Install.

First, choose the cell range D5:D11. Then, go to the Home tab and choose Code39 from the Font list.

Eventually, you will receive the Barcode Numbers for your Products using Code39 in Excel.

3. Use of Code128 Font to Change Numbers to Barcode

Code128 has 106 distinct barcode layouts. Moreover, “Code128” encapsulates numbers, letters, and the whole 128 ASCII character set. Like the previous methods, we will add Code128 in Excel and then convert the number into Barcode.

📌 Steps:

From any website, we’ll get the font “Code128” (just search with Download Barcode font).
The downloaded file will be zipped. Firstly, unzip the downloaded file >> double click on the Code128 >> Code128 (True Type) window will appear.
After that, click on Install.