ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   barcode in excel (https://www.excelbanter.com/excel-worksheet-functions/75670-barcode-excel.html)

katrien

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

Dav

barcode in excel
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519682


David McRitchie

barcode in excel
 
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" wrote
I would think the number just has to be formated with a barcode font.
Have you got the barcode font?




Thomas Lutz

barcode in excel
 
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
wrote:

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



All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com