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

Top