Resolved Questions

HCDE

How to keep hyphen in barcode

Tagged With:-

I've created barcode breaksheets, that when scanned will index employee data. I am having problems with the employee ssn as it has hyphens that aren't added to the barcode. The cell is currently formatted to add the hyphens when a person keys in the ssn. I'm so new to this, any help is appreciated.

Operating System: Windows10

Application: Excel 2016

04-03-17 7 year(s) ago

Report Abuse


Ben	Best Answer Answer from HCDE: I tested by adding hyphens manually and it did produce the barcode the way I wanted. I originally formatted the cell with a number format ( in the numbers group in Excel) that would automatically add the dashes. My guess is I just need to enter them manually to avoid this issue. Barcode Types that can encode Alphanumeric/Special Characters: •Code 128 •Code 39 •Data Matrix Barcode Types that can encode Numeric Characters: •Interleaved 2 of 5 •UPC & EAN Posted 7 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (4)

HCDE	I'm using the ID Automation 39XS Posted 7 year(s) ago (0) (0) Report Abuse

Ben

Hello,

I am not able to re-create the issue. After using the formula to encode the data (which appends the exclamation points), does the encoded data appear to include the hyphens? See if you can view the hyphens in the encoded data. What is the exact name of the barcode font that you are applying to the data?

The standard Code 39 character set is capable of encoding the hyphen. View the Code 39 character set chart.

Posted 7 year(s) ago

(0)

Report Abuse

HCDE	I am creating a Code 39 barcode, using the following formula. =code39(B1) Posted 7 year(s) ago (0) (0) Report Abuse

Ben

What barcode type are you creating?

Some barcode types encode only numeric while others can encode alphanumeric and special characters.

Barcode Types that can encode Alphanumeric/Special Characters:
•Code 128
•Code 39
•Data Matrix

Barcode Types that can encode Numeric Characters:
•Interleaved 2 of 5
•UPC & EAN

Excel Example using Code 128, Code 39, and Interleaved 2 of 5.

Interleaved 2 of 5 cannot encode the hyphen because it only encodes numeric values.

Posted 7 year(s) ago

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must starts with "http://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always starts with " http:// ")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 Characters are allowed. Current Count: 0

Your comment on this answer

Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must start with "http://" or "https://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always start with "http://" or "https://")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 characters are allowed. Current Count: 0

My Profile

You may answer and comment on any thread according to the Terms and Conditions.