Field with Bar Codes beginning with 0

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

Pat Coleman

Have an inventory spreadsheet with a colum called barcodes

Some barcodes begin with the numberic value 0 ( Zero )

we could have

50060192754
00075325498

however, the barcode begining with 0 gets truncated to 75325498

The problem is compounded as the worksheet is linked to access where the
values are all wrong also.

any ideas ??
 
Pat said:
Have an inventory spreadsheet with a colum called barcodes

Some barcodes begin with the numberic value 0 ( Zero )

we could have

50060192754
00075325498

however, the barcode begining with 0 gets truncated to 75325498

The problem is compounded as the worksheet is linked to access where the
values are all wrong also.

any ideas ??
Click to expand...

Pat,

I think generally that bar codes, zip codes, part numbers and such
should be treated as TEXT, and not numbers. Most applications don't call
for math to be done on these numbers. That said, the Access database
should be set up as numbers, as well as the Excel spreadsheet. If it's
not possible, you could have the Custom format / Number / 00000000000

???Helps???

Beege
 
Pat said:
Have an inventory spreadsheet with a colum called barcodes

Some barcodes begin with the numberic value 0 ( Zero )

we could have

50060192754
00075325498

however, the barcode begining with 0 gets truncated to 75325498

The problem is compounded as the worksheet is linked to access where the
values are all wrong also.

any ideas ??
Click to expand...

Pat,

I think that bar codes, zip codes, part numbers, telephone numbers,
should all be treated as TEXT. Most people don't need to perform math on
these. If it's possible to format these as text in Access and Excel,
things would be easier. Other than that,
Format/cells/custom/"00000000000", without the quotes, will give you a
fixed length "number"

??Helps??

Beege
 
Back
Top