Forum Discussion
When I paste a long number, Excel turns it into scientific notation and changes numbers.
Here's an example. I have a long number (it's from a license plate/bar code):
00100018320523710862
Whether I use my bar code software's export-excel function, or PASTE the number directly, here is what I get:
1.00018E+17 |
If I then format the cell as a number, I get:
100018320523710000 |
As you can see, I have lost the '0862' at the end of my number. Any ideas?
after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl
35 Replies
when you will save in database that time convert value into toString() like
Convert.toString(00100018320523710862)
then it will save original value in database.
- would pre-formatting the column or row to "Number" do the trick?
No, due to the 15 digit limit for numbers in Excel
Mr. Orrell
yes you're right!
no matter how long the number - in the cell it will only show 15 digits - the rest being zeroes...
thanks
You might also like to add your vote here
That's by design, you may see up to 11 digits, see https://support.microsoft.com/en-us/help/2643223/long-numbers-are-displayed-incorrectly-in-excel
- I also have the same problem and tried all the possible formatting and never shows the original number. How do you get the money back?
Hello Keith
Excel can only operate with 15 digits. Any digits beyond will be changed to 0.
Change the number format to Text.
