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
TS1970
Copper Contributor
Hi Keith Kargl
If you need detailed instructions, please see attached, in case you are familiar with the functionality in XL you will need to:
1- copy your long numbers into a .txt file. Save it somewhere on your machine (or in any cloud you can access it)
2- open XL, select from the "Data" menu the option "From Text/CSV". Search for your file and click "Import"
3- don't click on "Load", but choose "Transform Data", validate your Data Type states "Text" and then click on "Close & Load"
4- select all the cells that you need from the list, and do a Copy/ Paste Values.
DONE!
TS
JaxNg
Jan 14, 2021Copper Contributor
wow.. thank you for your solution. Worked wonder .. no exactly the same steps from #3 but import from text file and specify and text column fixed it.