New User? Sign Up  |  Sign In  |  Help
IDAutomation Logo
Barcode support and
tutorials from IDAutomation
and the community.		 Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions

UPC EAN Bar Codes not Working in Excel from Number cells


Hi,
I tried to do simple automation in Excel 16.32 Mac (for later ID 2020 use) with an EAN13 and CODE128a (using IDAutomation_OfficeVBA). The CODE128a works as expected.
But when I type =EAN13(FIELDNUMBER) I get an error. The same field works with other codes like CODE128a or UPC - only EAN is not working (see screenshot). Am I missing something?

Thanks in advance,
Christoph

Operating System: OSX 10.14.6

Application: Excel 16.32
Attachments:

12-18-19     4.9 year(s) ago    

  Report Abuse

 

Brant

Best Answer

Try a formula that converts the cells to text and then guarantees 13 digits. For example:
=EAN13(TEXT(A2,"0000000000000"))

image

Posted 4.9 year(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (2)
@Brant Thanks for your answer. Well … an EAN 13 Code should be out of 13 digits, isn't it? The article you linked mentions the necessity of the number 0 filling up to 14 digits. But this isn't working as well. Something is missing for IDAutomation in specialty and I can't find it. See Screenshot > ok - isn't loading. So here is the code:
01234567890128 >> EAN13=(A1) >> #BEZUG
1234567890128 >> EAN13=(A1) >> #BEZUG

Posted 4.9 year(s) ago

(0)
(0)
   Report Abuse
UPC and EAN barcodes require only a specific amount of characters. Refer to the FAQ for more information about the number of characters that may be entered.

https://www.barcodefaq.com/1d/upc-ean/



Posted 4.9 year(s) ago

(0)
(0)
   Report Abuse
 Categories
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  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
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  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

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

 © Copyright 2021 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook