Forum Discussion
When I paste a long number, Excel turns it into scientific notation and changes numbers.
- Apr 14, 2022
after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl
- BobOrrellAug 22, 2018Iron Contributor
No, due to the 15 digit limit for numbers in Excel
- Lorenzo KimAug 22, 2018Bronze Contributor
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
- Aaron WhiteOct 19, 2018Copper Contributor
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.