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...
after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl
Hello Keith
Excel can only operate with 15 digits. Any digits beyond will be changed to 0.
Change the number format to Text.
This does not work. When you change the number to text, you still get scientific notation.
In my experience, once the number is converted, you've lost the original number. If the cell is formatted as text prior to entering the number, you will retain the original value. If you have an existing .CSV file, you can use the Text Import Wizard (Data>Get External Data>From Text) to open the file, and set the column format as text during the import process, and it should retain the values as well.
FelipeSpinelMicrosoft
This solved the problem, thank you!
