How do I keep Excel from dropping my numbers to 0 after 15 digits

G

Guest

I am doing large number data entry, and excel is automatically converting my
numbers to zeros after the first 15 digits...
123456789123456789 comes out looking like 123456789123456000
It also appears to be calculating against the incorrect values.
Can anyone help???
 
D

Dave Peterson

Excel keeps track of 15 significant digits.

If you're using these as text (phone numbers/id numbers), then preformat those
cells as text or start your data entry with an apostrophe:
'12345678901234567890

Are you trying to do calculations against these values?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does Excel replace any digits beyond 15 with zeros? 2
Cell Number Format 1
I cannot enter a number containing more than 15 digits in Excel 1
15+ digit numbers 3
How do I keep a 17 digit number from ending in "0" in excel? 6
numbers cannot appear until 15 digit if ended with '0' 1
How do I stop Excel from dropping leading zeros? 9
How do I stop decimal being placed in a 3 digit whole number 4

Top