Field with Bar Codes beginning with 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Coleman - 24 Jan 2008 18:25 GMT

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 ??

Reply to this Message

Beege - 24 Jan 2008 18:35 GMT

> Have an inventory spreadsheet with a colum called barcodes
>
[quoted text clipped - 11 lines]
>
> any ideas ??

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

Reply to this Message

Bob I - 24 Jan 2008 18:37 GMT

Format as Text, or prefix the entry with ' a single quote/apostrophe

> Have an inventory spreadsheet with a colum called barcodes
>
[quoted text clipped - 11 lines]
>
> any ideas ??

Reply to this Message

Beege - 24 Jan 2008 18:41 GMT

> Have an inventory spreadsheet with a colum called barcodes
>
[quoted text clipped - 11 lines]
>
> any ideas ??

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

Reply to this Message