This happens because when Excel sees long numbers, it tries to format it to the scientific notation (or the 'E' notation to be precise). Even if
formula bar at the top, Excel re -displays the number as 1.23456789E-23 (or thereabouts).
Default number format in Excel is General therefore you can display up to 11 digits in a cell. Workaround. To work around this issue, use one of ...
Excel keeps converting long numbers to scientific notation when open csv files. How do I prevent Excel from doing this?
We all know that Excel can be a powerful tool, however in an effort to anticipate the need of a user, Excel can also make it difficult to create spreadsheets for ...
This tells Excel that the data after the apostrophe is not a number, but text, excel then does NOT convert this value to scientific notation. This is ...
In Excel put a ' at the beginning of the cell and it will convert it from a string
I have a long number (it's from a license plate/bar code):
... problem by expanding the column or, if that doesn't work, by changing the format of the cells. How to Display Full Tracking Numbers in Your Cells in Excel 2013
You will need to format new cells as Text then type in the numbers again. Hmmm, so is there anything else we can do to avoid having to re ...