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.
Read More: How to Create Barcode in Excel (3 Easy Methods)
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.
Read More: How to Generate Barcode Numbers in Excel (with Easy Steps)
Similar Readings
- Creating a Barcode Scanner Macro in Excel (with Easy Steps)
- How to Make Auto Enter with Barcode Scanner in Excel
- How to Calculate Barcode Check Digit with Excel Formula
- Creating Barcode Scanner to Track Check in & Check out Time in Excel
- How to Move Barcode Scanner to Next Row in Excel (2 Ways)
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.
- First, choose the cell range D5:D11. Then, go to the Home menu and click on Fonts. Then, choose Code128.
- Eventually, by using Code128 font, you will receive the Barcode Numbers for your Products in Excel.
Read More: How to Use EAN 13 Barcode Generator in Excel (2 Easy Ways)
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. If you have any questions, concerns, or suggestions, please leave them in the comments section of our blog ExcelDemy.
Related Articles
- How to Use Barcode Scanner in Excel (2 Suitable Ways)
- Barcode Scanner Entry to Excel Database with Timestamp (3 Basic Cases)
- How to Create Barcode Without Font in Excel (2 Smart Methods)
- How to Use Barcode Scanner for Inventory in Excel (with Easy Steps)
- [Solved] Barcode Scanner Not Going to Next Line in Excel
- How to Create Barcode Using 3 of 9 Font in Excel
