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
Create a new column and format as a text: https://support.microsoft.com/en-gb/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c#:~:text=In%20its%20simplest%20form%2C%20the,code%20you%20want%20to%20apply%22)
Ex. If your values are in column L, row 27 then create a new column next to it (column M). And type the following: =TEXT(L27, ##########) and hit Enter.
Note: enter as many hashtags as you need to show all your digits