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 

Bdath's avatar
Bdath
Copper Contributor
Nov 29, 2023

simongoh 

I tried this, but excel is still not pasting the last 2 digits correctly.  any suggestions?

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 29, 2023

Bdath 

In modern Excel we have an option to disable such behaviour

If copy/paste the value from initial post it returns as

  • mythails's avatar
    mythails
    Copper Contributor
    Mar 21, 2025

    Can someone mark this as a solution? This is the only thing that works for me. Thanks SergeiBaklan 

  • Bdath's avatar
    Bdath
    Copper Contributor
    Nov 30, 2023
    thanks for showing me this. It looks like I have a 'restricted version' or a totally different version of Excel. I don't have the automatic data conversion options. I'll see if someone in our IT department can help me with this.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 30, 2023

      Bdath 

      It shall be on Office 365 subscription at least on Current channel, perhaps on Monthly Enterprise. If you are on semi-annual channel, or not on 365, afraid that functionality is not available.

Resources