Forum Discussion
Solved
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
when I try this, only a few lines of data are changed back over correctly. for example, I'm copying 17 lines of data with numbers like this: "1241205200000006168." they all copy over with -0000 at the end. when I try this formatting solution, only 2-3 lines change to the correct -6168 and the rest stay as -0000. are there any other solutions that works for the full set of data? (and yes, I have tried selecting other fraction formatting options)
Depending on Excel version, you may have the possibility to disable 'keeping only the first 15 digits'.
File: Options: Data; Automatic Data Conversion