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

Get FREE Advanced Excel Exercises with Solutions!

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.

Sample data on how to convert numbers to barcode in Excel


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.

Select Cell range and right click on mouse to choose Format Cells

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

Select Text option from Format cells

  • 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

Enter a formula to copy a clomn

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

Drag down the fill handle

  • 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.

Install barcode font.

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.

Converting Numbers to Barcode Using Barcode Font

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

Final data with barcode font

Read More: How to Generate 2D Barcode 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.

Install code 39

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

Using Code 39 to Convert Numbers to Barcode

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

Barcode of the product using Code39

Read More: How to Generate Barcode Numbers 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.

Install Code 128

  • First, choose the cell range D5:D11. Then, go to the Home menu and click on Fonts. Then, choose Code128.

Using Code 128 to Convert Numbers to Barcode

  • Eventually, by using Code128 font, you will receive the Barcode Numbers for your Products in Excel.

Final barcode using code 128

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


Download Practice Workbook

You can download the practice workbook from the following download button.


Conclusion

Follow these steps and stages to convert numbers to barcode in excel. You are welcome to download the workbook and use it for your own practice.


Related Articles


<< Go Back to Create Barcode in ExcelBarcode 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.
Al Ikram Amit
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo