• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

How to generate a barcode in Excel

By admin on August 11, 2017April 19, 2019

This tip shows you how to generate a barcode in Excel that will enable you to track stock, sales, purchases or fixed assets.
Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016.
Excel has no built-in functionality to generate a barcode.  However, this is easily achievable by simply downloading and installing a font.

This tip will enable you to generate a barcode in Excel by using 39 barcodes.  Code 39, or Code 3 of 9 as it is sometimes referred to, is the most used barcode and is scannable by every barcode scanner.  It can encode 26 upper-case letters, 10 digits and 7 special characters.
To generate a barcode, follow these steps:
Download and install the free barcode font from idautomation. This is a fully-functional, freeware font.  Please refer to the free product section of their license agreement for additional information.
Once the font has been installed, select the cell in which you want to generate the barcode.
Enter the value for the barcode.
Change the font from your standard font style to “IDAutomationHC39M Free Version”.

Once the font has been changed, the text will be converted into a barcode.
This is an easy way to not only generate a barcode, but also one that can be printed and scanned.
The post How to generate a barcode in Excel appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Join Sally as she helps you forge ahead, making use of the Sage Intelligence Connector module
How to print and display formulas in an Excel workbook

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd