Forum Discussion
When I paste a long number, Excel turns it into scientific notation and changes numbers.
after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl
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
I was having this same problem: 20 digit number was getting 00000s at the end or being stored in scientific notation.
The work around: format the cell as text and add a ' in front of the number string. The cell will not display the ' before the number and will display only the full number without zeros at the end.
Ex. 123456789123456789 was showing up as 123456789123456000 when formatted as anumber and showing in scientific notation when formatted as text. Changed cell formatting to text and entered '123456789123456789 as the cell value. Cell displays 123456789123456789 accurately afterwards.
They didn't mention these when purchasing.
We are constantly dealing with the problems of software that should have reached perfection for years. We also have to use 3rd party software because it changes the long numbers in the cells and removes the dots of the IP addresses.
