The complete list of formulas and detailed instructions for creating different barcodes in Excel are available in this PDF documentation. You can also generate other types of barcodes such as Code 128 with the formula "=Encode_Code128Auto(A1)" or EAN13 with the formula “=Encode_EAN13(A1)”.
Cell B1 contains a barcode formula for generating a Code 39 barcode.
Enter "123456" into cell A1 and the formula "=Encode_Code39(A1)" into cell B1 of the spreadsheet and press the return key.To return to Excel, click on Excel -> Close and Return to Microsoft Excel. You should see a new module Modules -> Module1 added in the Project panel. Next, click on File -> Import File, select the "Encoder.bas" file (available in officebarcodeaddin.zip), and click on the Open button. When the Visual Basic Editor is launched, make sure it is the active Window by clicking on its title bar. In Excel, click on the menu Tools -> Macro -> Visual Basic Editor. We will first need to import the Excel barcode formulas into the spreadsheet.Launch Microsoft Excel, and create a Blank Workbook.
Tutorial on creating barcodes in Excel for Mac Note - Sample Excel spreadsheets with the barcode formulas to generate various types of barcodes are available in the Samples folder.