Forum Discussion

Keith Kargl's avatar
Keith Kargl
Copper Contributor
Jun 16, 2017
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...
excel
  • simongoh's avatar
    simongoh
    Apr 14, 2022

    after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl 

lwoosley's avatar
lwoosley
Copper Contributor
Aug 02, 2018
This does not work. When you change the number to text, you still get scientific notation.
Infonutt's avatar
Infonutt
Copper Contributor
Apr 13, 2022

lwoosleyAgree. Doesn't matter if you change to text.

Resources