If you need to use fonts OR need to merge the encoded data, the GS1-128 Font Suite with VBA Encoder (PRODUCT OPTION 2) is the appropriate solution.

Code 128 Font For Excel Install The GS1

Download the demo or purchase and install the GS1-128 Font Suite.

Because Excel 2008, does not include VBA, consider using the AppleScript solution with the Universal or Code 128 Mac Fonts.

While this screenshot is for Windows, the location of the VBA file required for format the data is located in the same path.

Access this location: Name of the file is IDAutomationUniversalGS1FontVBA.bas 3.

Open the file in an editor and copy the contents of the file.

Run Excel. 5. Select Tools - Macro - Visual Basic Editor.

Select Insert - Module.

Paste the code copied from the IDAutomationUniversalGS1FontVBA.bas file into the module.

Select Debug - Compile VBAProject.

If there are issues, contact IDAutomations Technical Support Chat.

We may have another file easier to import.

Example to create a GS1-128 barcode using the data: (01)3001234567890.

Enter the formula in lowercase: In Cell A1, enter 202013001234567890m13.

In Cell B1, enter idautomationunic128(A1,True) NOTE: The 202 is used before any Application Identifier that requires an FNC1.

Setting the second parameter to True allows the function to process any data that has a before it.

Press return. The encoded data appears as uppercase letters.

Right-click the column and select Format Cells.

Select the Font tab.

The font in the GS1 Font Suite begins with IDAutomationGS1 followed by a numeric value that indicates the height.

To select the appropriate barcode font for your specification, review this guide: 14.

In the Font options, select the IDAutomationGS1 barcode font.

Example IDAutomationGS1 64 or IDAutomationGS1 52.

Must be among the following file types -.jpg,.gif,.png.bmp.

Legal Notices. Barcode Fonts Components Scanners Support Contact Us.

Code 128 Font For Excel Mac