Barcode Cell Format

  • Thread starter Thread starter Pat Coleman
  • Start date Start date
P

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.
 
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.
 
Back
Top