Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions |