Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i have a spreadsheet with a column of style numbers. I want to create a
second column that convert the first column to a barcode using the barcode font is there a way to doa this via a formula instead of one cel at a time ? |
#2
![]() |
|||
|
|||
![]()
Steps to convert a list of numbers to barcode font in Excel:
The formula adds an asterisk before and after each number in the first column, which is necessary for the barcode font to work properly. Each cell in the second column should now display the corresponding number from the first column in barcode font.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If you data is in column A then in b1 put the formula
=a1 Then copy the formula down column b. Then select Column B and change font to bar Code. "Convert numbers to barcode in spreadht" wrote: i have a spreadsheet with a column of style numbers. I want to create a second column that convert the first column to a barcode using the barcode font is there a way to doa this via a formula instead of one cel at a time ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert list of different numbers to thousands | Excel Discussion (Misc queries) | |||
looking for free barcode font for excel | New Users to Excel | |||
Convert My Data into Barcode 128 B | Excel Worksheet Functions | |||
Convert arial text field to barcode | Excel Worksheet Functions | |||
changing numbers into a barcode using excel | Excel Worksheet Functions |