Using Code 3 of 9 barcode

[kkeeble]

If cell A1 has a number 123456 that uses the font Code 3 of 9 it will not scan, but if i put an * as the start and stop bit it will scan.

my question is if cell A1 = *5* and cell B1 = *2* how can i multiple cell A1 and B1 to show up as 10 in cell C1? (cell C1=A1*B1)

 

[shg]

You could format the cells as \*0\* to make the asterisks appear.

 

[kkeeble]

That didnt work..unless im doing it wrong.

 

[shg]

Works here:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]

*1234*​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

*123*​

[/td][td="bgcolor:#E5E5E5"]

*1357*​

[/td][td]B2: =A1+A2[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td][/td][td][/td][td]Format of A1: \*0\*[/td][/tr]
[/table]

 

[kkeeble]

got it to work.. i was typing in *1234* and then formatting the cell to \*0\*

Thnak you

 

[shg]

You're welcome.

 

[kkeeble]

If cell A1=QPI-12LZ-01 and cell A2=A1 cell A2 is setup with Free 3 of 9 font. the bar code will not scan. But if i put make A1=*QPI-12LZ-01*, cell A2 will scan correctly.
How can i make the barcode look like it has the start and stop bits with out having the *'s show up in cell A1? I have formatted cell A1 with \*0\* but the bar code still doesn't scan correctly.

 

[shg]

Format the cells as \*0\*;\*0\*;\*0\*;\*@\*

 

[kkeeble]

If cell A1 has data in it and cell B1 is formatted with \*0\*;\*0\*;\*0\*;\*@\* with a font type of Code 3 of 9, why is when i delete the data in cell A1 that cell B1 still show a bar code that scans as 0 (Zero). How can i make cell B1 show no barcode when cell A1 si blank.