Spreadsheet with readable barcode data when printed.
 

After formating the cells with barcode fonts and entering barcode, using
barcode reader, I'm unable to read the printed sheet with the barcode reader.
Is this a local problem or is there something I'm forgeting to include in my
formating?

Thanks
BarDoomed

Did you include "*" before and after data.
Example: ="*" & a1 & "*" this cell will need to be formatted with the
barcode font of course.

"BarDoomed" wrote:

After formating the cells with barcode fonts and entering barcode, using
barcode reader, I'm unable to read the printed sheet with the barcode reader.
Is this a local problem or is there something I'm forgeting to include in my
formating?

Thanks
BarDoomed

You have gotten me another step forward James, now is there a way to default
the "*" into the cells and have the data to enter between them? This asking a
lot isn't it?

"James W." wrote:

Did you include "*" before and after data.
Example: ="*" & a1 & "*" this cell will need to be formatted with the
barcode font of course.

"BarDoomed" wrote:

After formating the cells with barcode fonts and entering barcode, using
barcode reader, I'm unable to read the printed sheet with the barcode reader.
Is this a local problem or is there something I'm forgeting to include in my
formating?

Thanks
BarDoomed

No,
You could use a formula in the adjacent column.
If your data is in column 'a' then insert this formula into however
many cells in column 'b' =if($a2="","","*" & $a2 &"*").

"BarDoomed" wrote:

You have gotten me another step forward James, now is there a way to default
the "*" into the cells and have the data to enter between them? This asking a
lot isn't it?

"James W." wrote:

Did you include "*" before and after data.
Example: ="*" & a1 & "*" this cell will need to be formatted with the
barcode font of course.

"BarDoomed" wrote:

After formating the cells with barcode fonts and entering barcode, using
barcode reader, I'm unable to read the printed sheet with the barcode reader.
Is this a local problem or is there something I'm forgeting to include in my
formating?

Thanks
BarDoomed

BarDoomed wrote...
You have gotten me another step forward James, now is there a way to
default
the "*" into the cells and have the data to enter between them? This
asking a
lot isn't it?
....

Your concern is display and printout, so you don't really need the
asterisks in the cells' contents. Since bar codes would be either
positive integers or text, use the custom number format (yes, NUMBER
format)

\*0\*;;;\*@\*

Positive numbers and text will display and print with delimiting
asterisks. Format these cells in barcode font and you should be good to
go.

It works!
Thanks to both of you. I should have found this Diss. Grp. a few days ago.


" wrote:

BarDoomed wrote...
You have gotten me another step forward James, now is there a way to
default
the "*" into the cells and have the data to enter between them? This
asking a
lot isn't it?
....

Your concern is display and printout, so you don't really need the
asterisks in the cells' contents. Since bar codes would be either
positive integers or text, use the custom number format (yes, NUMBER
format)

\*0\*;;;\*@\*

Positive numbers and text will display and print with delimiting
asterisks. Format these cells in barcode font and you should be good to
go.

Bar code fonts are not only difficult to use, they also produce
extremely poor quality bar codes. The only easy to use bar code font
is a Code 39 bar code font because Code 39 does not require any check
digit calculations to be performed on the data that you are encoding.
Code 39 does however require that you put an asterisk (*) at the
beginning and the end of the string of characters that you are trying
to encode. Even if you do this, you can still end up with very poor
quality bar codes that can be difficult to read.


The best solution would be to use a bar code ActiveX control instead
of a bar code font. A good bar code ActiveX control will
automatically add the start and stop codes to either end of the bar
code and it will also automatically calculate and add any required
check digits. It will also produce a very high quality graphic image
of a bar code that should print perfectly no matter what printer you
print to.

The best bar code ActiveX control on the market is available at the
following URL:
http://www.taltech.com/products/activex_barcodes.html
You can download a demo version of the product from the above URL and
the demo even comes with a sample Excel spreadsheet that demonstrates
how to use it in Excel.




On Wed, 29 Dec 2004 08:25:10 -0800, BarDoomed
wrote:

After formating the cells with barcode fonts and entering barcode, using
barcode reader, I'm unable to read the printed sheet with the barcode reader.
Is this a local problem or is there something I'm forgeting to include in my
formating?

Thanks
BarDoomed