Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2003 bar codes 1

Status
Not open for further replies.

Rae03

IS-IT--Management
Jun 19, 2003
36
NL
Is there a way to convert a UPC number to a bar code on a
excel sheet?
 
rae03,

you need to have the proper font installed on your machine. google for "upc fonts", "barcode fonts" etc. then install in your font directory. you may have to reboot, but then you should be able to change the font of a cell to the barcode.
have done this in office 2k no problem with code 39 fonts. just make sure you get a true type font.

regards,

longhair
 
Yes thank you I already have the proper font but I need to
know how you take a numeric UPC in one column and covert to
a bar code in another column?
 
rae03,

i'm not in the office at the moment, but if i remember correctly this is what i did:
change a1 to the barcode font. put your numeric sequence in a2. in a1 enter "=a2". you may have to increase the size of a1 to show the barcode.

regards,

longhair
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top