• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

draw barcode in excel

hoomantt

hoomantt

Member
In the name of GOD

Hello , sir . Chandoo

I am from Iran & know English a little . but I use your site and guides a lot with translators programs.

thank you so so much for your helps.

Now. I need help , I am working in a company(sales unit-operational researches),and I make many excel reports for my boss , now I need a (printable & visible) barcode to insert down of my reports pages (in this company we use WYSE systems , then I can not install any things and do (.exe) files ; and I need your help in excel with VB or ADD-IN and not (.exe) files) ,please , please , please.

I want write a name of a report or a date (2011/04/17) and excel gives to me a barcode picture .

At the end , thank you for your help and if you don’t answer me , not be afraid and no matter and I love you, more than every time .

My e-mail : hoomanamooh@yahoo.com
 
Welcome to the forum, hoomantt!


To use barcodes in Excel, you need to install a barcode font. There are slight variatians in different bar code fonts, but you can generally find a free download by doing a google search for "Barcode font".

http://www.google.com/search?q=barcode+fonts


Once you have the font installed on your computer, you can then use it in Excel. Then, a easy way to create the barcodes is to have one cell contain the human-readable text, and another cell (with the barcode font) have a formula link to the previous cell.
 
Last edited:
hi dear Hui;

i am a beginner in excel and should do this work(barcode in excel) please please please ;

can you send me an excel file that works?

thanks and thanks and thanks so much .
 
hello ;

every format that is possible for you,

i want write a name and a number (like john101) in a cell and excel gives me a barcode picture for use under my reports for my boss.

really really thank you and i pray for you to find and recieve every things that want from GOD.

wait for you.
 
hello again

thanks for your help

i like a pharmacode barcode,

please

can ypu help me?

thanks and thanks
 
1. Do an internet search for "pharmacode barcode font", choose the one you want

2. Install font in the font folder on your computer.

3. In Excel, change the font of a cell to the barcode
 
Hello Hoomantt

I have found that most barcode scanners will work with a format called Code 39 - there are many free websites offering this as a font that can be installed on any PC.

Once installed you type the text you want into a cell and change the font to this new one (Often called "Free 3 of 9")

It's easiest if you have two cells, one in a human readable format, the second in barcode format.

Barcodes often have a start and end character that the scanner reads to know how to process the information. With the Code 39 system this character is *

A typical barcode would then be *Hoomantt* as the human readable


I usually do this:

Cell A1 contains the human readable form and in cell A2 I put

="*"&A1&"*" which I then format to Free 3 of 9 font


Hope that makes sense


Keep safe
 
Hi, Hoomantt!
If I were you I'd start with Code 39 or Code 128, not with Pharmacode unless you'd specifically work with those type of products.
Regards!
 
@leona313
Hi!

Here you asked if it was for free:
http://chandoo.org/forum/threads/how-to-create-code-128-in-excel.5052/#post-90269
but here you posted one that's not for free:
leona313 said:
here is the barcode in excel guide
Click to expand...
unless you accept a watermark that is supposed to invalidate the code usage as it says here:
http://www.keepautomation.com/guide/excel_barcode_addin.html
"Evaluation Restriction
This barcode generator for Excel evaluation/trial version can only be used for demo or testing purposes for the reason that a "KA Barcode" watermark exists on generated barcode images."
Am I wrong?

Regards!
 
You must log in or register to reply here.
Back
Top