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

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???

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

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?

Topmom5 wrote:

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???

--

Dave Peterson