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

T

Topmom5

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

How do I stop Excel from dropping leading zeros? 2
Can't use 16 digits?? 2
Compare 2 lists of random numbers - Excel 2007 4
I have 138 numbers, how do i get 15 random numbers from my data? 4
Imported numbers from Excel change to scientific notation 4
Excel Changes My Last Digit to Zero 1
How do I stop Outlook '03 from mangling my phone numbers? 3
How do I keep a 17 digit number from ending in "0" in excel? 6

Top