This tutorial demonstrates how to remove scientific notation in Excel and Google Sheets.
Remove Scientific Notation
If you enter or paste a large number into a cell, Excel will automatically format it to scientific notation (eg. 1,23E+10). Say that you enter the following number in cell B2.
Now when you press Enter, Excel will automatically format the number to scientific notation, since the cell is too narrow (or there are more than 12 numerics in the number), and formatted as General.
To avoid this, and force Excel to display numbers as you wrote them, you can just double-click between column headings (in this case B and C).
As a result, the cell width is adjusted to fit the whole number, and scientific notation is removed.
Note: If you want to completely remove the scientific notation, even if the cell width is too narrow, you have to change the cell format to Number. To do this, follow the next steps.
1. (1) Right-click a cell where you want to remove scientific notation, and (2) choose Format Cells…
2. In the Format Cells window, (1) select the Number category, (2) set the number of decimal places to 0, and (3) click OK.
Now the scientific notation is removed.
Since the cell is not wide enough, you don’t see the whole number, but only the bunch of hashtags. In order to display the whole number, just double-click between columns headings to expand the cell width.
Note: If you need it back, you can easily add scientific notation.
Remove Scientific Notation in Google Sheets
Google Sheets don’t use scientific notation. In case that a number entered in a cell is longer than the width of the cell, only the visible part of the number will be displayed, without changing the format.