This tip shows you how to generate a barcode in Excel that will enable you to  track stock, sales, purchases or fixed assets. Applies To: Microsoft  Excel  for Windows 2010, 2013, and 2016. Excel has no built-in functionality to generate a barcode.   However, this is easily achievable by simply downloading and installing a font.
This tip will enable you to generate a barcode in Excel by using 39 barcodes.   Code 39, or Code 3 of 9 as it is sometimes referred to, is the most used barcode and is scannable by every barcode scanner.   It can encode 26 upper-case letters, 10 digits and 7 special characters. To generate a barcode, follow these steps:

• Download and install the free barcode font from idautomation. This is a fully-functional, freeware font.   Please refer to the free product section of their license agreement for additional information.
• Once the font has been installed, select the cell in which you want to generate the barcode.
• Enter the value for the barcode.
• Change the font from your standard font style to "IDAutomationHC39M Free Version".

• Once the font has been changed, the text will be converted into a barcode.

This is an easy way to not only generate a barcode, but also one that can be printed and scanned.