Weird Number Truncating

D

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
 
N

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
 
D

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
 
G

Guest

put a

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

before the number...
 
D

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
 
Top