Forum Discussion
Keith Kargl
Jun 16, 2017Copper Contributor
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...
- Apr 14, 2022
after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl
CarolMaxwell
Apr 07, 2022Copper Contributor
Hi Keith,
Not sure if you have solved this but for others struggling with the same problem. This has worked for me.
When copying over to excel or typing by selecting the block. ( You get the scientific number)
Then select the cell block formula bar above after the number and press enter. It should automatically correct the number to the proper format.
Hope this helps.