UPC.EAN.UCCEAN.CODE128.

EAN13.UPCA.EAN8.UPCE.CODE39.GS1-128.ITF14.PLESSY.CODE93.

Generate Barcodes in Excel (Excel Barcode Fonts)

Other topics

Aeromium Barcode Fonts comes with a complete set of Excel Formulas for generating barcodes in Excel easily. The Aeromium software package, implemented using Font technology, allows barcodes to be treated as text in Excel. You will be able to simultaneously change the size of multiple barcodes residing in different cells quickly by simply selecting them and changing their font size.

Installing the Barcode Fonts Excel Formulas


Excel 2002/2003

1. Launch Microsoft Excel.
2. Goto Tools > Add-Ins.
3. Click on the Browse button.
4. Navigate to the "formulas" directory ("C:\Program Files\Aeromium\formulas")
5. Select the "Aeromium Barcode Fonts.xla" Add-In file
6. Click on the OK button to install the Add-In. You should be able see the dialog as below.




Excel 2007

1. Launch Microsoft Excel.
2. Click on the Office icon button.



3. Click on the Excel Options button.
4. In the Excel Options dialog, click on the Add-Ins item.
5. Click on the Browse button.
6. Navigate to the "formulas" directory ("C:\Program Files\Aeromium\formulas")
7. Select the "Aeromium Barcode Fonts.xla" Add-In file
8. Click on the OK button to install the Add-In. You should be able see the dialog as below.

Setting the Excel Security Settings


If you face problems using the Aeromium Excel Formulas, make sure you have setup the Security Settings in Excel.

1. Launch Microsoft Excel.
2. Click on Tools > Macro > Security
3. Set the security level to Medium

Using the Excel Formulas


1. Make sure you have installed the Aeromium Barcode Fonts package and installed the Barcode Fonts Excel Add-In as described above.
2. Launch Microsoft Excel.
3. In your Excel spreadsheet, key in the data "12345678" in the A2 cell.
4. We will be creating the barcode in the next column.
5. In cell B1, key in "=AeroCode39(A1)" and press the Enter key.
6. You will see the string "*12345678*" generated in cell B1.
7. Change the font of cell B2 to FontCode39H3. You can repeat the steps above for cell A2 and A3.


Refer to the table below for a complete list of the Formulas and Barcode Fonts to use.

Complete List of Barcode Excel Formulas


Barcode

Excel Formula Parameters Barcode Fonts
Code 128 Auto AeroCode128Auto Parameter 1 - Data value to be encoded
FontCode128H1                                                   
FontCode128H2
FontCode128H3
FontCode128H4
FontCode128H5
FontCode128H6

Code 128 A AeroCode128A Parameter 1 - Data value to be encoded
FontCode128H1
FontCode128H2
FontCode128H3
FontCode128H4
FontCode128H5
FontCode128H6

Code 128 B AeroCode128B Parameter 1 - Data value to be encoded
FontCode128H1
FontCode128H2
FontCode128H3
FontCode128H4
FontCode128H5
FontCode128H6

Code 128 C AeroCode128C Parameter 1 - Data value to be encoded
FontCode128H1
FontCode128H2
FontCode128H3
FontCode128H4
FontCode128H5
FontCode128H6

Code39 AeroCode39 Parameter 1 - Data value to be encoded
Parameter 2 - Check Digit. 1 for Yes, 0 for No.
FontCode39H1
FontCode39H2
FontCode39H3
FontCode39H4
FontCode39H5
FontCode39H6

Code39 Extended AeroCode39Extended Parameter 1 - Data value to be encoded
Parameter 2 - Check Digit. 1 for Yes, 0 for No.
FontCode39H1
FontCode39H2
FontCode39H3
FontCode39H4
FontCode39H5
FontCode39H6

EAN8 AeroEAN8 Parameter 1 - Data value to be encoded
(Note : Parameter for specifying Extended Style is not required. If you require the Extended Style, simply choose the Extended Style font.)
Standard Style
FontCodeEANH1
FontCodeEANH2
FontCodeEANH3
FontCodeEANH4
FontCodeEANH5
FontCodeEANH6

Extended Style
FontCodeEANEH1
FontCodeEANEH2
FontCodeEANEH3
FontCodeEANEH4
FontCodeEANEH5
FontCodeEANEH6

EAN13/ISBN/ISSN AeroEAN13 Parameter 1 - Data value to be encoded
Parameter 2 - Extended Style. 1 for Yes, 0 for No. If set to 1, please remember to set to the Extended Style font.
Standard Style
FontCodeEANH1
FontCodeEANH2
FontCodeEANH3
FontCodeEANH4
FontCodeEANH5
FontCodeEANH6

Extended Style
FontCodeEANEH1
FontCodeEANEH2
FontCodeEANEH3
FontCodeEANEH4
FontCodeEANEH5
FontCodeEANEH6

Extension 2 (EXT2) AeroEXT2 Parameter 1 - Data value to be encoded
FontCodeEANH1
FontCodeEANH2
FontCodeEANH3
FontCodeEANH4
FontCodeEANH5
FontCodeEANH6

Extension 5 (EXT5) AeroEXT5 Parameter 1 - Data value to be encoded
FontCodeEANH1
FontCodeEANH2
FontCodeEANH3
FontCodeEANH4
FontCodeEANH5
FontCodeEANH6

Interleaved 2 of 5 (I2of5) AeroI2of5 Parameter 1 - Data value to be encoded
Parameter 2 - Check Digit. 1 for Yes, 0 for No.
FontCodeI2of5H1
FontCodeI2of5H2
FontCodeI2of5H3
FontCodeI2of5H4
FontCodeI2of5H5
FontCodeI2of5H6

Industrial 2 of 5 AeroIndustrial2of5 Parameter 1 - Data value to be encoded
Parameter 2 - Check Digit. 1 for Yes, 0 for No.
FontCodeINT2of5H1
FontCodeINT2of5H2
FontCodeINT2of5H3
FontCodeINT2of5H4
FontCodeINT2of5H5
FontCodeINT2of5H6

ITF14 AeroITF14 Parameter 1 - Data value to be encoded
Parameter 2 - Check Digit. 1 for Yes, 0 for No.
Parameter 3 - Bearers Bar. 1 for Rectangle, 0 for Top/Bottom.
FontCodeITF14H1
FontCodeITF14H2
FontCodeITF14H3
FontCodeITF14H4
FontCodeITF14H5
FontCodeITF14H6

Modified Plessy AeroModifiedPlessy Parameter 1 - Data value to be encoded
Parameter 2 - Check Digit. 1 for Yes, 0 for No.
FontCodeMPH1
FontCodeMPH2
FontCodeMPH3
FontCodeMPH4
FontCodeMPH5
FontCodeMPH6

POSTNET AeroPOSTNET Parameter 1 -Data value to be encoded
FontCodePOSTNET

UPCA AeroUPCA Parameter 1 - Data value to be encoded
Parameter 2 - Extended Style. 1 for Yes, 0 for No.
Standard Style
FontCodeUPCH1
FontCodeUPCH2
FontCodeUPCH3
FontCodeUPCH4
FontCodeUPCH5
FontCodeUPCH6

Extended Style
FontCodeUPCEH1
FontCodeUPCEH2
FontCodeUPCEH3
FontCodeUPCEH4
FontCodeUPCEH5
FontCodeUPCEH6

UPCE AeroUPCE Parameter 1 - Data value to be encoded
Parameter 2 - Extended Style. 1 for Yes, 0 for No.
Standard Style
FontCodeUPCH1
FontCodeUPCH2
FontCodeUPCH3
FontCodeUPCH4
FontCodeUPCH5
FontCodeUPCH6

Extended Style
FontCodeUPCEH1
FontCodeUPCEH2
FontCodeUPCEH3
FontCodeUPCEH4
FontCodeUPCEH5
FontCodeUPCEH6

UCCEAN AeroUCCEAN Parameter 1 - Data value to be encoded e.g. (00)123456789012345675(12)101E FontCode128H1
FontCode128H2
FontCode128H3
FontCode128H4
FontCode128H5
FontCode128H6



Goto Barcode Generator

Back to Barcode Software and Fonts main page.



Copyright(c) 2009-2014 Aeromium Barcode Software & Fonts.
All Rights Reserved.

Login form