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
Lorenzo Kim
Aug 22, 2018Bronze Contributor
would pre-formatting the column or row to "Number" do the trick?
- BobOrrellAug 22, 2018Iron Contributor
No, due to the 15 digit limit for numbers in Excel
- Lorenzo KimAug 22, 2018Bronze Contributor
Mr. Orrell
yes you're right!
no matter how long the number - in the cell it will only show 15 digits - the rest being zeroes...
thanks
- guruniqueJul 16, 2024Copper Contributor
They didn't mention these when purchasing.
We are constantly dealing with the problems of software that should have reached perfection for years. We also have to use 3rd party software because it changes the long numbers in the cells and removes the dots of the IP addresses.