Barcode

[johnsamm]

How do I add a barcode to a cell? In particlar I'm trying to have a cell say E7 with a prod ID and I want cell F7 to reflect this info as a barcode, and have the ability to change the ID number with the change also reflected in the F7 barcode!

Johnsamm

 

[jmthompson]

I've always used a special font to generate barcodes, 3of9 for example

 

[johnsamm]

Sorry, but what I was looking for was a step by step process to do this! I have no clue on doing the barcode setup let alone the tying the code to a cell reference!
thanks
johnsamm

 

[jmthompson]

If you're creating your own barcodes; it should be simple. Once you install the appropriate font, format column F with the barcode font then enter "=E7" in F7.

 

[johnsamm]

Jen, thanks for the info but does Excel 2010 come with barcode fonts if so what should I be looking for in the Fonts section?

again thanks for the quick replies.
Johnsamm

 

[jmthompson]

I don't think it does. Do you have a barcode reader?

 

[johnsamm]

No I don't, I'm developing a spreadsheet for purpose of doing stackups for the PCB mfr Industries and I thought adding a barcode for the prod ID would be a plus! Oh and the spreedsheet is going to be distributed freely as a shareware type function.
Johnsamm

 

[Xtrimmer]

I had a similar problem in the past and found this addin worked for most of the popular barcodes in use today. It is a small installer download that adds the fonts and functions to Excel and Word.

http://www.idautomation.com/fonts/tools/word-excel-addin/

 

[johnsamm]

thanks Xtrimer for that link!
Johnsamm

 

[TechnicalSwordsman]

You could also create Code 39 without that Add In. See:

How to Create Code 39 in Excel:
http://www.youtube.com/watch?v=JWKe829OuVY