how to convert list of numbers to barcode font
 

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 ?

Answer: how to convert list of numbers to barcode font
 

Steps to convert a list of numbers to barcode font in Excel:

1. Download and install a barcode font on your computer.
2. Select the column of numbers that you want to convert to barcode font.
3. Right-click on the selected column and choose "Format Cells" from the context menu.
4. In the Format Cells dialog box, select the "Font" tab and choose the barcode font that you installed from the list of available fonts.
5. Click "OK" to close the Format Cells dialog box.
6. To create a second column that automatically converts the first column to barcode font, use the following formula in the first cell of the second column:
   Formula:

   ---

   =CONCATENATE("*",A1,"*") 


   ---

7. Copy the formula down to the rest of the cells in the second column.

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.

how to convert list of numbers to barcode font
 

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 ?