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

How do I setup data in Excel on my mac to work w/ 2of5 font


I am using the demo version of the font right now. If I can get it to work, I'll buy the tools needed to achieve my goal. I need to be able to create a variable I2of5 bar code in InDesign (CC 2019) from a linked Excel (.csv) data file using Datamerge.

Operating System: Mac OS 10.14

Application: InDesign CC2019 & Mac Excel 16.22

02-13-19     5.7 year(s) ago    

  Report Abuse

 

Ben

Best Answer

For Mac, we recommend the Universal Font Package (compatible for Mac) to create Interleaved 2 of 5 and other barcode types. In order to produce barcodes in InDesign, another application such as Excel must be used to format the data similar to this tutorial:

How to format data in Excel (2004,2011, and 2016) using Universal Fonts and VBA

The example creates a Code 128 barcode using the formula =idautomation_uni_c128(cell location,False)

For Interleaved 2 of 5, use the formula: =idautomation_uni_i2of5(cell location,3, TRUE)

After formatting the data, it should appear as a group of letters. Save the file and then perform a data merge into InDesign. Select the IDAutomationS Uni M (demo font) or IDAutomation Uni M (licensed font) to produce I2of5.

This InDesign Data Merge example shows how to merge Excel with InDesign.

Posted 5.7 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.

 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