Use Scientific Notation in Excel & Google Sheets

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

 

 

Add Scientific Notation

By default, Excel uses scientific notation to shorten large numbers. If you have removed scientific notation (e.g., 1,23E+10), you can easily bring it back. Say you have the following number in cell B2.

 

 

1. To add scientific notation, and make the number format shorter, select the cell (B2),
2. In the Ribbon, go to the Home tab.
3. In the Number Format drop-down, choose General.

 

 

When you change the cell format back to General, Excel automatically adds scientific notation.

 

 

Scientific Notation in Google Sheets

Google sheets will also automatically default to a scientific notation format for long numbers.

If you have removed it however, you can easily add it back.

In the menu, select Format > Number and then select Scientific.

The number will then once again be formatted with Scientific Notation.