Sage 100

Bar Code Font formula for Excel - Does anyone know if a formula is required in Excel to produce a properly formated bar code? Obviously, the cell has to have the BC font. Below is what Crystal uses. formula = BarcodeC128B({SO_SalesOrderWrk.SalesOrderNo})

Searching the Internet, it appears that you have to install an add on. Below is a link from the Microsoft site. http://www.barcoderesource.com/officemarketplacefreebarcodefont.shtml Looking for alternatives. Is anyone using this functionality?

You can use a free barcode font like free of nine. It is a code 39 font although it doesn't support spaces. Search for ""free of nine"" on google

Thanks. Unfortunately, spaces will be an issue.

@JeffSchwenk code 39 does supports spaces. ""The Code 39 specification defines 43 characters, consisting of uppercase letters (A through Z), numeric digits (0 through 9) and a number of special characters (-, ., $, /, +, %, and space). "" You need to include an asterisk at the beginning and end of the information to be barcoded, so to barcode 123 ABC, the field would be *123 ABC*. Hope that helps.

I would try it but have had problems with the barcode breaking in middle with the free of nine barcode. If you purchase a true code 39 it might work better. The leading and trailing asterisks definitely required.

http://azalea.com/code-128/excel/

Looks like a winner.................