👋 3 ways I can help you! 1) Looking to buy a barcode scanner? Check out my reviews spreadsheeto.com/barcode-scanner/ 2) Free 30-minute Excel course (100,000+ students) spreadsheeto.com 3) Busy? Hire me! spreadsheeto.com/excel-consultant/

@floresd77

Жыл бұрын

Hello there Mr. Spreadsheeto and to all that are reading this. I need some help on how to create barcodes for each employee.. So basically we are using SCLogic Scan Software which we use to Scan and track our incoming and outgoing mail. Our coworker made one for each employee and worked but he is no longer with the company. I would like to do the same to make it a faster process when receive incoming delivers and outgoing mail so we don't have to walk up to the laptop and type in our username and password as we have to log off each time. Also would this work if I put in all the information of each employee with their username and password using this method?? Sorry all new to this.. Thank You All.....👋

This was so incredibly useful! Thank you so much!

Brilliant - easy to follow and got the job done

3 minutes and 40 seconds of pure gold.

VERY HELPFUL, DETAILED AND CRISP VIDEO THANKYOU!

Super basic & easy to understand. Love it! Looking forward for more tutorials💕 thank you! always keep safe

@Spreadsheeto

2 жыл бұрын

I'm glad you like it :) Thanks for watching.

Thanks a lot, very helpful and easy to do!

Thanks it’s very detailed. I want to learn how to create my unique barcodes

Thanks for link & teaching

Thank you sir it really helps

you are the best . thank you .

Thank you!

Just an FYI you are my hero Thank you for this video

thank you for this video

great to found this informative account! question: is the product number the same as a sku number? thanks!

THANK YOU SO MUCH!!! You Saved me from a lot of head

Nice Video Kasper

great stuff it worked :-)

Hey there. I don't understand what I am doing wrong here. I followed your instruction to a T but I am getting an error message

Very useful but what app did u use to scan it on ur phone

do you have any idea if it works on Mac os, been trying to get it installed

hi please when I press the enter key after putting in the parenthesis it does not work. Could I be doing something wrongly.

great video but i don't scan my barcode , can you help me ?

how would i add a barcoad font on the mobile version of excel?

Can I find one for generating barcodes for driving license?

Please share more advanced function and data nmanipulation technique in EXCEL

@Spreadsheeto

2 жыл бұрын

Thanks for your suggestion! :)

How to make lowercase letters?

How do I create a barcode on exel mobile?

Does this work on retail POS system? I mean will it be picked up by retail scanner?

@Stratelier

2 ай бұрын

Yes, though how the scanner will interpret the code it just read is a different matter. Store I work at, for example, our shelf tags are rendered using ITF (interleaved 2 of 5) with 14 digits, and our markdown labels get printed using Code 128 barcodes (with 20 digits). But, know that several barcode schemas (including UPC) embed a "check digit" somewhere that you WILL need to account for when rendering the barcode, without which the scanner will assume it misread the bars and do nothing.

Great content ❤. I had one question though, how you know what digit or numbere you want to encode to Barcode? How do you do it what numbers you want to use !!!

@Stratelier

2 ай бұрын

That question is actually 75% of the work. In many practical cases you are dealing with items whose barcode numbers (e.g. a UPC or GTIN) are already defined for you. For example, if you look at the barcode on a soup can you may see something like "0 51000 01251 7" _(

In my Excel we are unable to down load barcode now to add in Excel

If I knew where you were right now, I'd hug you.

What is the purpose of bracket and formula. We shouldn't we do a just change in font. Is bracket (formula) is compulsory?

@Bandrik

7 ай бұрын

Most barcodes including the Code 39 format shown here have a beginning and ending marker. It helps to tell the barcode reader where a barcode begins and ends, and what direction to read it in if it's upside down. The formula being used is simply to automate adding those "( )" parts, which in the barcode font become the start and end makers. Otherwise you'd have to manually type those in by hand. So a barcode like this (123) When scanned will read as 123

Did Excel stop allowing this formula? It's not working for me.

@spreadsheeto Thank you so much

Hi Sir good afternoon

Please be more specific in what keys you are pressing. I cannot follow this as I don't know what you are doing half the time, especially at 2:14

It's too bad the Web version of Excel (aka. Office 365) doesn't strictly support these fonts. I had a nasty usecase where the barcode fonts my file used did render onscreen, but NOT WHEN PRINTING (aka. the whole reason to use a barcode font in the first place). I kludged together an alternative solution in a week (and it works), but it wasn't fun that I _needed_ to do that to begin with.

@Spreadsheeto

2 ай бұрын

I agree. I'm glad you found something that works :)

@Stratelier

2 ай бұрын

@@Spreadsheeto I said to myself "if it supports Web standards then it must support Unicode" -- it didn't take long (relatively speaking) to find the "box drawing / block elements" Unicode range, build a working transcription of input characters into (a binary version of) their barcodings, then substitute the appropriate Unicode characters to render the barcode stripe by individual stripe. Again, super kludgy and all, but I just needed it to work.

When I enter the ="("&....its not converting the numbers over (@2:30mark) Can anyone help?

@janadyck4037

19 күн бұрын

same problem

I cant change the font 😢

doesnt work

thanks man! but it does not work, does not scan the barcode generated

@Stratelier

2 ай бұрын

Been there personally. There could be two reasons for this: 1 - If the barcode schema includes an error-check digit, failing to include it (and/or getting it wrong) will cause your barcode to not scan, because that's literally the reason error-check digits exist: to prove that the rest of the code was in fact scanned correctly. 2 - You didn't actually format your character string correctly. This requires a little knowledge of the layout for the barcode schema you're using, and the character set of the barcode font you're using. Wikipedia can brief you about the former, while a character-map tool can let you analyze the latter. As an example, I've used a "UPC font" on occasion and while the UPC schema only has about 24 distinct symbols, the font's actual character set contained at least twice as many, organizing them into groups for: - Start/stop code _(which for UPCs is actually the same code, but the font encoded them separately)_ - "Odd parity" digits _(UPC digits are encoded as 7 bits grouped into patterns of 2 stripes + 2 spaces; "odd parity" digits have 3 bits set and 4 bits cleared)_ - "Even parity" digits _(4 bits set, 3 bits cleared; this helps inform whether the barcode is being scanned left-to-right or right-to-left)_ - Centerpoint marker _(the barcode switches from "odd" to "even" parity digits at this point; for this and other reasons, a UPC-A will always have exactly 30 stripes of various widths and spacings)_ - Combined start code + odd-parity digit - Combined even-parity digit + stop code

@doursaque

2 ай бұрын

@@Stratelier thank you, I'll try again!

@Stratelier

2 ай бұрын

@@doursaque Wow, I was not actually expecting a reply given the age of your prior comment. Anyway: Researching how the barcode is structured is probably the bigger help, but the amount of work involved varies depending on which barcode schema you're trying to use. As for decoding the character set in the font, that's actually easy: just build a 16x8 table with something like =CHAR(16*row+column) in each cell to observe which glyph gets rendered for each input. Another step is starting with a known-scannable barcode and trying to decode/decipher it manually -- this will help alert you to the existence of any "metadata" alongside the actual encoded data. For example, the store I work at uses ITF (interleaved 2 of 5) type barcodes for scannable shelf tags, but we also have specialized markdown stickers which use Code 128 type barcodes. Notably, the latter encodes 20 numeric digits but if you decipher the bars by hand it turns out there are actually just _10_ encoded data values (each value representing two digits) and _two_ metadata values (specific to Code 128).

please i purchased bar codes thinking they would come in pictures but insted they gave me numbers? how do i convert the number to a picture? thanks

For me if I add 3600567 it shows on the barcode as 536005676. It adds 5 and 6😔

@gummansgubbe6225

Жыл бұрын

You should try it without the "(" in the beginning (and the end?). Looking at the first image of the video you can see some heading lines. It bet those are the "(".

@Stratelier

2 ай бұрын

Certain barcode schemas actually require a bit of "metadata" to be encoded beyond the actual data itself. Code 128, for example, defines 3 subsets (aka. 3 ways to interpret the same pattern of stripes) so its "start code" must necessarily tell it which subset to refer to. Similarly, there may be an error-checking digit added to the barcode, which is not necessarily counted as part of the data encoded.

@TuanLVT

2 ай бұрын

@@gummansgubbe6225 doesnt work :/

@TuanLVT

2 ай бұрын

@@Stratelier i heard excel needs some kind of macro to make barcode to really work with scanner readers

@Stratelier

2 ай бұрын

@@TuanLVT Macros automate parts of the process, yes. But depending on the barcode schema it can be technically possible to do it all yourself ... it's just a bit of work. For example, I built a series of formulas to render UPC-A barcodes _stripe by individual stripe_ and the results actually do work with barcode scanners (which was indeed the point of doing it). It doesn't use anything beyond ordinary formulas, a monospace font, a few select Unicode characters, and some research on my part for how UPCs are actually encoded/decoded.