How to Remove Scientific Notation in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on April 3, 2023

This tutorial demonstrates how to remove scientific notation in Excel and Google Sheets.


remove scientific notation 2


Remove Scientific Notation

If you enter or paste a large number into a cell, Excel automatically formats it to scientific notation (e.g., 1,23E+10). Say you enter the following number in cell B2.


remove scientific notation 1


Now when you press ENTER, Excel automatically formats the number to scientific notation, since the cell is too narrow (or there are more than 12 numerals in the number), and formatted as General.


remove scientific notation 2


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).


remove scientific notation 3


As a result, the cell width is adjusted to fit the whole number, and scientific notation is removed.


remove scientific notation 4


Note: If you want to completely remove the scientific notation, even if the cell width is too narrow, change the cell format to Number.

  1. Right-click the cell where you want to remove scientific notation, and choose Format Cells…


remove scientific notation 5


  1. In the Format Cells window, select the Number category, set the number of decimal places to 0, and click OK.


remove scientific notation 6


Now the scientific notation is removed.


remove scientific notation 7


Since the cell is not wide enough, you don’t see the whole number, but only the bunch of hashtags. 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 also defaults to a scientific notation format for long numbers, but you can remove it and change to a different number format.


scientific notation gs show


  1. In the Menu, select Format > Number. The default ticked is Automatic, which is why long numbers are automatically given a scientific format.
  2. Select Number.


scientific notation gs format


  1. If necessary, resize the column to show the entire number with the new format applied.


scientific notation gs number format

AI Formula Generator

Try for Free

See all How-To Articles