Barcode Cell Format

[Pat Coleman]

If I want to store bar codes in a range of cells in Excel, how do I format
the cell so the barcode appears as scanned in.

We are scanning in Barcode from our inventory to our excel stock book.

I am doing it now but when we export it out or link it to an access table,
it either does not appear or is truncated.

[[email protected]]

Hi,
Try pointing to this URL http://www.skandata.com/ttf.html
Hope this helps
-Anu

[Thomas Lutz]

My guess is that you are scanning in bar codes that consist of long
strings of numeric digits. If the cell is formatted with the "General"
format, Excel will convert the bar code data to a number and store it
as a number. Long numbers will automatically be converted to floating
point values. For example, a bar code number like:
1234567898765430
will be converted to the following numeric value :
1.23457E+15

Change the cell formatting to "Text" and Excel will leave the number
alone and not convert it.


On Tue, 2 May 2006 18:11:52 -0400, "Pat Coleman"
<[email protected]> wrote:

>If I want to store bar codes in a range of cells in Excel, how do I format
>the cell so the barcode appears as scanned in.
>
>We are scanning in Barcode from our inventory to our excel stock book.
>
>I am doing it now but when we export it out or link it to an access table,
>it either does not appear or is truncated.
>

[caryfloric]

I am a little confused by your question and I am not sure whether we are meeting the same problem. Here is my situation: I need to generate barcode images in Excel for inventory management but the generated barcode images are floating over the Excel and it is not one image fixed in on cell. Why?

[FDibbins]

@ cary...you may not have noticed, but that thread is almost 7 years old?