Barcode table

[DORAMIUS]

I thought there might have been a post about this, but I've been searching for about 2 hours with nothing.

I'm using Excel 2007 (compatibility mode 97-2003).

I import a table of numbers that appear in column A. They look similar to this (999-9-9-00). I need a complex conditional format in order to create a barcode in column B, of the number that appears in column A. All numbers have to have a * before and after the information (IE: *999-9-9-00*) in order for the barcode font to be scanable.

Is this possible?

 

[TheNoocH]

try this

Excel Workbook
	A	B
1	999-9-9-00	*999-9-9-00*
2	123-45-67	*123-45-67*
3	987-6-5-43	*987-6-5-43*
Sheet1

 

[Phox]

I might be misunderstanding, but is this what youre looking for?

="*"&A1&"*"

Copy and paste down as far as necessary.

 

[sanrv1f]

not sure I understood your requirement correctly, may be this

In B2 conditional formatting -> Formula is

=AND(LEFT(A2,1)="*",RIGHT(A2,1)="*")

 

[DORAMIUS]

Thanks Nooch, and everyone else. I didn't realize '&' allowed the * to be displayed.

You all Rock.

 

[TheNoocH]

Thanks Nooch, and everyone else. I didn't realize '&' allowed the * to be displayed.

You all Rock.

as long as the * is enclosed in quotes it will treat it as a string...