barcode in excel

How do i create a barcode in excel with the numeric code ?

I would think the number just has to be formated with a barcode font. Have you got the barcode font?

However there are many different barcode standards and thus fonts, to name but a few for UCC-12 (UPC-A and UPC-E), EAN-13, EAN-8, ISSN, Bookland and ISBN.

You need to make sure you are using the appropraite font for your needs. You also may need to purchase the font in the first instance.

Regards

DAv

For some information on barcode fonts see
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dav" <[email protected]> wrote
> I would think the number just has to be formated with a barcode font.
> Have you got the barcode font?

Bar code fonts are not only tricky to use, they also produce very porr
quality bar codes that can be difficult to read. Bar codes incorporate
special start and stop codes as well as check digits that must be
calculated. You cannot simply select text and change its font to a bar
code font and get a readable bar code. Code 39 is the only bar code
symbology where you can use a bar code font without having to write
code however you have to add an asterisk * character at the beginning
and end of the message that you want to encode in the bar code font
before you apply the font.

In any case, the best way to add bar codes to an Excel spreadsheet is
to use a bar code ActiveX control instead of a bar code font. The best
one on the market is available from TAL Technologies. You can download
a demo version at:
http://www.taltech.com/support/bcax/index.html
The demo comes with a sample Excel spreadsheet that shows how to
insert the ActiveX control in a worksheet.




On Tue, 7 Mar 2006 04:17:29 -0800, katrien
<[email protected]> wrote:

>How do i create a barcode in excel with the numeric code ?