Bar Codes

I work at a help desk in a university setting.  Teachers are using Excel more 
and more to create grade books.  SOme of them need to format parts of their 
data into a bar code (items like an ID number).  How can I do this?

Thanks in advance,
Michael
mjlucas@stritch.edu
0
mjlucas (1)
8/30/2005 4:09:05 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
646 Views

Similar Articles

[PageSpeed] 41

Download a bar code font, I always use 3 of 9 
....http://www.barcodesinc.com/free-barcode-font/

On your worksheet format the cell to this barcode font. For it to work 
properly you must include "*" at the start and end of your data. Start and 
stop data points.  For example in cell A2 enter = "*" & B2 & "*" or you could 
always use a custom format to include the *.

Hope that helps
James

"mjlucas@stritch.edu" wrote:

> I work at a help desk in a university setting.  Teachers are using Excel more 
> and more to create grade books.  SOme of them need to format parts of their 
> data into a bar code (items like an ID number).  How can I do this?
> 
> Thanks in advance,
> Michael
> mjlucas@stritch.edu
0
JamesW (13)
8/30/2005 4:42:04 PM
hi,
excel comes with a barcode font built in. 3 of 9 barcode sometimes called 39 
barcode. 
Format>cells>font tab
scroll to the top of the font list.
if it is not there, you may have an installation problem.
See my post to 3 of 9 inquery under excel setup posted 8/26/05 entitled "3 
of 9" font type. he insisted that he did not have 39 barcode but as it turned 
out, he had an installation problem. once he reinstalled, he had the font. 
but I also post a web site where 39 barcode could be downloaded.

Regards
FSt1

"mjlucas@stritch.edu" wrote:

> I work at a help desk in a university setting.  Teachers are using Excel more 
> and more to create grade books.  SOme of them need to format parts of their 
> data into a bar code (items like an ID number).  How can I do this?
> 
> Thanks in advance,
> Michael
> mjlucas@stritch.edu
0
FSt1 (238)
8/30/2005 5:51:13 PM
You can get   "Free 3 of 9" bar code [Free]  at  Matthew Welch's site
   http://www.squaregear.net/fonts/free3of9.shtml

Additional links to barcode information notably to Russ Adam's    http://www.barcode-1.net/
-- 
---
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

"mjlucas@stritch.edu" <mjlucas@stritch.edu@discussions.microsoft.com> wrote in message
news:7C20C1FE-5950-4AF9-B932-6EBE738771DD@microsoft.com...
> I work at a help desk in a university setting.  Teachers are using Excel more
> and more to create grade books.  SOme of them need to format parts of their
> data into a bar code (items like an ID number).  How can I do this?
>
> Thanks in advance,
> Michael
> mjlucas@stritch.edu


0
8/31/2005 3:00:14 AM
(left out last line)

You can get   "Free 3 of 9" bar code [Free]  at  Matthew Welch's site
   http://www.squaregear.net/fonts/free3of9.shtml

Additional links to barcode information notably to Russ Adam's
    http://www.barcode-1.net/
can be found on my http://www.mvps.org/dmcritchie/excel/mailmerg.htm


0
8/31/2005 7:12:50 AM
Reply:

Similar Artilces:

Change bars color
Hello, I have a dinamic chart to show the cash flow position, a scrool bar chagne the data to the past and to the future (estimate), what I am looking for is, to have an easy identification of the estimated period I would like to chage the color of the bar. I am using an Stacked Column chart with two variables. any Ideias? -- regards from Brazil Thanks in advance for your feedback. Marcelo What I usually do when I want to show a column chart with one color within a certain range and another color elsewhere, is create two series, one each color, and use formulas to change on series ...

Can the color of the Command Bar be changed?
When you open up a window to show the contents of a folder, just below the usual Menu Bar is the Command Bar with menus like "Organize" and "Views." That Command Bar has a sickly blue-green color. Is there any way to change the color of the Command Bar? At the very least, I would like that color to be less saturated. -- Steven L. ...

Color coding the excel sheets
I have a user that wants to color code her worksheet tabs. I know that you can individually color code each one by right-clicking. Is there a way to have excel launch with each tab set to a color (ex. sheet 1=red, sheet2=green, sheet3=yellow, etc.)? She wants this to launch this way every time. Thanks. Shane Certainly a workbook_open event could do this but why not just set a template with the sheets colored as desired>save it>use it.. -- Don Guillett SalesAid Software donaldb@281.com "Shane" <Shane@discussions.microsoft.com> wrote in message news:BE5570A2-016...

DATE sort bar has disappeared from SENT box
I've inexplicably lost my DATE sort bar in my SENT box. Outlook 2002, XP Pro. I've dug here and scratched there, but cannot uncover an answer as to why it's missing and how to get it back. Hit the OfficeUpdate.com website to engage in Office XP SP 1 and/or 2...I'm current, but alas, still no DATE sort bar in the SENT folder. One little bar--so valuable--so easily mis-placed! Thanks for any advice-- Timmo in AK Try right-clicking in the gray title bar, then select to customize your current view. Click on the "Fields" button to see the list of available fi...

100% Stacked Bar chart, two bars, want percent as well as real value
I am attempting to chart the following: Series 1 - Values over the prior 30 days Series 2 - Values over the prior 12 months I would like to show both data series as 100% bar charts, so users of the information can compare percentage of the last 30 days with percentage of the same piece of data over the last 12 months. So, for example the two data series might look like this: Series 1 20 25 45 65 Series 2 211 324 403 822 I want to display both the actual value, and the percentage of the total, for each series, in the labels. For some reason, showing percentage is not an option. Why is th...

Secure code in Excel & Power Point ADD-INS
Is there any way to secure code in Excel & Power Point ADD-INS, except the password defined in VBA ? No. Use VB to create COM addins. ************ Anne Troy VBA Project Manager www.OfficeArticles.com <CLarkou@gmail.com> wrote in message news:1132296881.379001.293560@o13g2000cwo.googlegroups.com... > Is there any way to secure code in Excel & Power Point ADD-INS, except > the password defined in VBA ? > Thanks a lot, these add-ins can be called in Access also, isn't? The COM add-ins can be created by Visual Basic code or it needs C++ ? You can use VB. -- ...

a frame window with its title bar on the top of its menu bar (overlapped) ...
Hi, This is related to a previous post of mine, for which I got a lot of help from people but the problem was still not resolved. I am reducing the problem to the following piece of code with only one class (CFrameWnd) involved. Please bear with me to look into the problem one more time. HINSTANCE h = AfxGetResourceHandle(); AfxSetResourceHandle(::GetModuleHandle(_T("current.dll"))); CFrameWnd *pFrm = (CFrameWnd*)RUNTIME_CLASS(CFrameWnd)->CreateObject(); pFrm->LoadFrame(IDR_MAINFRAME, WS_OVERLAPPEDWINDOW | FWS_ADDTOTITLE); pFrm->ShowWindow(SW_SHOW); AfxSetResourceHand...

Color code quoted text
Is there no way to color code quoted text in the standard message reading view? I've searched high and low and can't seem to find anything about this. The newsreader in Opera does a terrific job of this, as do many other programs. Bob Graham Yes, but since you decided to keep secret the version of Outlook you are = using, all bets are off. --=81 Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. =20 After furious head scratching, rvgrahamsevatenein@sbcglobal...

X error bar
Hello, I can find in Format Data Series the 'Y Error Bar' but nowhere can I fnd the 'X Error Bar'. How can I get this one? Office 2000. Thank you Hi Daniel, In order to have x error bars you need to use the xy scatter chart. Cheers Andy Daniel wrote: > Hello, I can find in Format Data Series the 'Y Error Bar' but nowhere can I > fnd the 'X Error Bar'. How can I get this one? > > Office 2000. > > Thank you > > > -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

How do you add error bars?
when i select my data series on my table, no selected data series appears under format Instead of selecting the series on the table (whatever that means), try selecting the data series in the chart. -- Regards, Tushar Mehta MS MVP Excel 2000-2004 www.tushar-mehta.com Excel, PowerPoint, and VBA tutorials and add-ins Custom Productivity Solutions leveraging MS Office In article <08ef01c3a991$89241060$a101280a@phx.gbl>, anonymous@discussions.microsoft.com says... > when i select my data series on my table, no selected > data series appears under format > ...

How do I show status bar on Publisher 2003?
The Status Bar in Publisher 2003 which is at the bottom of the screen and shows many page numbers suddenly vanished. I see no way of makling it reappear. This toolbar was called "Status Bar' in Office 2000 - Publisher'. There is no reference to this item in Pub 2003. 2. Pub 2003 has slowed down almost to a halt. If I insert a woed text file, it takes a couple of minutes per page; and then, even after a long wait, it does not insert all pages of the inserted document. It has to be done manually. 3. While using Pub 2003, the response to move from one page to another, appear...

Stacked bar, bar and line graph
I am trying to create a chart with the following data: Series 1-8 with bars Series 9-10 with stacked bars (two different data) Series 1-10 with a line across all Is this possible in one chart? This should give you ideas: http://peltiertech.com/WordPress/2008/08/07/clustered-stacked-column-combo-chart-with-lines/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JoAnn" <JoAnn@discussions.microsoft.com> wrote in message news:ECE4C227-CB81-46F7-9D4E-B07ED353AFD2@microsoft.com... ...

Code 19 with Amex issued by Costco
I get an error : Code 19 when I swipe American Express cards that are issued by Costco. All others swipe fine. I can manually type the Costco cards, and they approve. Anyone else been down this road before ? Thanks for any help. Ed This is a multi-part message in MIME format. ------=_NextPart_000_06F2_01C71CC9.BD72F3A0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Ed, Check with your processor as the Costco card and others have a special = discount rate (higher) attached to them and you may not be able to = accept them. --=20 Jef...

Status Bar
I am trying to fix a db created by someone else. Somehow, I'm hoping you can explain, they disabled the status bar. I check the Options and it is still checked??? What other means could be used to disable it? How can I make it visible again. QB QB, Two places... Start-Up Properties and Tools - Options... one of those is unchecked. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "QB" <QB@discussions.micros...

Getting "Accounts" on menu bar
My girlfriend has an "Accounts" button on her menu tool bar (not sure which one, advanced, standard???) which allows her to select which account she's sending an e- mail "from". I can't find a way to find that item to put on the menu bar. Please help. This is available in Outlook 2002 and later. What version are you using? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching googl...

How to write networking code in VBA?
I am quite familiar with BSD networking API. But I don't know the first thing about network programming in VBA. I've done a Google search, and I will continue to do so. But so far, I have not found a concrete example (that I can access). I would very much appreciate some hand-holding. Here is what I want to do in a macro. It's really very rudimentary. on error goto done connect(TCP) to ipAddress:portNumber for each line (read from a file or otherwise provided by the macro) send line (terminated by \r\n on the wire) recv response (one line terminated by \r...

Vary bar colors by bar
I would like to vary the colors on a bar chart by bar. The chart plots 7 points agains a standard. The standard has the value of 100. The points change based on information received weekly. This will cause the bars to, sometimes, be above the standard and, sometimes, below the standard. How can I force the bars to change colors with every update so that when the bar goes over the chart it will be green but when it falls below the chart it will be red? Tim Hi, Have a look at Jon's example of conditional charting. http://peltiertech.com/Excel/Charts/ConditionalChart1.html Cheers Andy ...

Conditional formatting code that looks up a list of criteria
Hi All I'm using Excel 2007, I have a brilliant conditional formatting code that applies conditional formatting to a column of data that contains 40 different product names. The code looks at strings in $C$95:$C$300 (user enters any text but always includes the product name somewhere). When it finds the product name it colours the cell for that product. My problem is that new product codes will need be added to the list. I'd like the user to be able to add new products to the list and the code pick up those new products and include them in the conditional formatting....

floating bar chart?
how do I create a floating bar chart to display the data bars as columns instead of rows? selecting the row button does not display the data correctly. Make a stacked column chart On chart, double click lower data series; format to have No Pattern and No Border best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Karol" <Karol@discussions.microsoft.com> wrote in message news:A4CA4496-860B-499F-A472-34385E628FDA@microsoft.com... > how do I create a floating bar chart to display the data bars as columns > instead of rows? selecting the ...

Diagnostic-Code: smtp; 4.4.1 Did not receive the expected protocol response.
Exchange 2003 We are able to send and receive emails to any domain except one domain. When someone from this particular domain replys to one of our emails or trys to send us an new email message their Exchange server returns the following error. ****Header Error***** Reporting-MTA: dns; mail.movgal.com Final-Recipient: rfc822;bwoodall@sourcexs.com Diagnostic-Code: smtp; 4.4.1 Did not receive the expected protocol response. Action: failed Status: 4.0.0 ***The body of that message contains**** This is a delivery status notification, automatically generated by MTA mail.movgal.com on Sun, 05 De...

"Calculation" in status bar
I have one woorkbook that the "Calculation" lite in the status bar stays on. I do not have "manual calculation" turned on. How can I fix? Not sure if this is the issue... XL: Calculate Message Remains in Status Bar If 65,536 Formula References http://support.microsoft.com/default.aspx?scid=kb;en-us;243495&Product=xlw HTH -- Dana DeLouis Win XP & Office 2003 "rich" <rmeyer@glenoaksescrow.com> wrote in message news:2da801c4ad68$639ec4d0$a601280a@phx.gbl... >I have one woorkbook that the "Calculation" lite in the > status bar ...

formula bar location
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel My formula bar sits immediately below the menu bar. When file open, they are &quot;under&quot; the formula bar so that the minimize/close buttons and file name are not visible. Is there any way to adjust the view settings so the files open below the formula bar? <br><br>Many thanks. The most common reason is that the Formula Bar is not really 'docked' at the bottom edge of the Menu Bar. Grab its left edge & drag it further up until it "snaps" into position. The o...

Access VB Managed DLL from un-managed Code of VC
Hi I have a managed DLL (class library) made in VB .NET 2003. I have to use the DLL in VC .NET 2003. My VC code is un-managed. How can I make the above work??? I created a simple windows console application to test my dll. In my VC project, I created an object of the class in VB DLL, it gives me ERROR that the 1. object can't be destroyed... 2. 'VBClassLibrary::TestClass' : illegal use of managed type 'VBClassLibrary::TestClass'; did you forget a '*'? I am not concerned about manage/un-managed code.. =MY DLL Code===========================================...

Area/ZIP codes
MS requires that we enter a zip code when Office is installed... I've moved since installation and need Outlook to change the default area code for contacts to my new area code. How do i change this? "Dave" <dhoffa1@mymail.indstate.edu> wrote in message news:0b8c01c3615c$01e1da10$a101280a@phx.gbl > MS requires that we enter a zip code when Office is > installed... I've moved since installation and need > Outlook to change the default area code for contacts to > my new area code. How do i change this? First it was zipcode (for postal mail). Then it wa...

Scroll bars disapear
Im sorry but am very new at excel. My scroll bars on the left and at the bottom have disapeared and I cannot get them back. Also the little thingy at the bottom of excel that allows you to select thru different sheets is gone. Its drving me up the wall and I cant figure it out.... Any help would be greatly appreciated. Thank you in advance Jen Jen, try tools options, and see if scroll bars and sheet tabs are checked -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always ap...