Weird Number Truncating

[djeans]

I am trying to create a spreadsheet for tracking items by barcode. Fo
what ever reason, any number containing more than 15 numbers, exce
changes all numbers after the 15th digit to zero.

For example:

7301010250174422
becomes
7301010250174420
when entered into an excel cell.

7301010250174422456
becomes
7301010250174420000

Is there anyway to fix this?

Thanks

Darro

 

[Niek Otten]

Hi Darron,

Excel's precision for numbers is 15 decimal digits.
Use text instead, either by preceding the number with a single quote (which
will not show) or by formatting the cell as text before entering the code.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[djeans]

I tried formatting the cell as text, but then it displayed the number a
7.30101E+15

How do I get it to display the number in text mode, but all 16 of th
numbers?

thank

 

[Guest]

put a

' (single quote...as it what you would use as apostrophe
in "don't")

before the number...

 

[djeans]

Thanks,

That worked to get the number to display correctly, but unfortunatel
defeated the purpose of what I was trying to do.

I wanted to quickly enter the info for many (more than a hundred) item
using a barcode scanner.

Having to put the ' in each cell before scanning would take longer tha
I want to spend on it.

Thanks for the help.

Darro

 

[JE McGimpsey]

Try preformatting the cells as Text.