Excel Will Not Post Long Numbers- They are Shortened by +16 and +17

[rebel123]

Excel Will Not Post Long Numbers- They are Shortened by +16 and +17.

I am using Google Sheets.
The number is 11120000000000300 and I can only see that number
when I hover my mouse, but the excel sheet reads "1.112E+16"
So how do I change that for all of the rows? I can drag down
the formula, so I just need that sequence.

And then another sequence is 102090000000001000 and
I can only read which actually shows as "1.0209E+17"

I put in BOLD font which ones I am talking about,
and you can see what it shows when I hover my mouse.

 

[mrshl9898]

So you want to see the number?

=TEXT(C2,"####")

Or format it as number

 

[jasonb75]

You need to format the cells as text before entering the numbers or precede them with an apostrophe.

If you do as suggested in the previous post then you will lose the last 2 digits (if you haven't already). Only the first 15 digits are retained when cells have a numeric format, subsequent digits will all be rounded to zero. Converting to text after these digits have been rounded will not restore the original values.

 

[rebel123]

Thanks mrshl9898 that was the correct answer. This website is awesome.
People at Harvard should use this when they solve or cannot solve advanced excel equations!

 

[mrshl9898]

Note what jason said, I tested it and it's right. Changing 102090000000001000 to 102090000000001001 will not work with my solution