Turn Off Scientific Notation in Google Sheets

Scientific notation in Google Sheets shows very large or very small numbers in a compact form like 1.23E+08 instead of 123,000,000. This guide shows you how to force Sheets to display full numbers instead, which is useful for IDs, serial numbers, and precise measurements. You only need a Google account and a sheet with the affected numbers.

What You’ll Need

A Google Sheets document containing numbers shown in scientific notation
Access to the Google Sheets menu bar (web browser or mobile app)
Knowledge of which cells or columns contain the values you want to fix

Step-by-Step

Open your Google Sheets document in a web browser or the mobile app.
Select the cells that display scientific notation. Click and drag to select a range, or click a column letter to select the entire column. To select multiple non-adjacent areas, hold Ctrl (Windows) or Command (Mac) while clicking.
Open the Format menu. In the top menu bar, click Format.
Choose Number. From the dropdown, hover over Number to reveal sub-options.
Select a plain number format. Click Number from the submenu. This removes scientific notation and shows the full value with up to two decimal places by default. For example, 1.23E+08 becomes 123,000,000.
Adjust decimal places if needed. If you need more or fewer decimals, go back to Format > Number > Custom number format and enter a pattern like 0 for no decimals, 0.00 for two decimals, or 0.#### for up to four decimals. Click Apply.
For text-like numbers (IDs, barcodes), the number format alone may still cause issues if the value exceeds 15 digits, because Sheets stores numbers with limited precision. To keep every digit exactly, you must treat the data as text. Select the cells, go to Format > Number > Plain text, then re-enter the values (or paste them as text). This prevents any rounding.
Check the result. After applying the format, the selected cells should display the full number without an “E” or exponent. If they still show scientific notation, the cell width may be too narrow; widen the column by dragging the edge of the column header.

Common Mistakes

Only changing the column width – Widening the column can hide scientific notation temporarily, but it does not change the underlying format. The notation will return if the number is large enough.
Using the “Automatic” format – Choosing Format > Number > Automatic lets Sheets decide, and it often reverts to scientific notation for large numbers. Always pick an explicit format like Number or Plain text.
Forgetting to select all affected cells – If you only format a few cells, others will still show scientific notation. Use Ctrl+A to select the entire sheet if needed.
Applying the format to the wrong column – When you click a column header, make sure you are on the correct sheet and column before formatting.
Expecting 16+ digit numbers to stay exact – Google Sheets stores numbers with about 15 significant digits. If you enter a 20-digit number, the last digits are lost regardless of formatting. You must use Plain text format and re-enter the data to preserve all digits.

Tips

Use custom formats for consistency – Instead of clicking “Number” each time, create a custom format like 0.000 to force three decimal places and no exponent.
Apply formatting to entire columns – If a column will always contain IDs or large numbers, format the whole column once so future entries are also correct.
Paste as plain text for long numbers – When copying data from another source, use Edit > Paste special > Paste values only and then set the format to Plain text to avoid scientific notation.
Use TEXT() for display-only changes – If you want to show a number as text in a formula without changing the original cell, use =TEXT(A1, "0") to display the full number as a string.
Check the formula bar – The formula bar always shows the underlying value. If the cell displays scientific notation but the formula bar shows the full number, it is purely a formatting issue and can be fixed with the steps above.

Troubleshooting

Still showing scientific notation after formatting? First, confirm the cell is selected and the format is set to Number (not Automatic). Then check the column width – if the column is too narrow, Sheets may show the exponent to save space. Drag the column header to widen it. If that does not work, close and reopen the sheet to refresh the display.

Numbers get rounded or show “0” after formatting? This happens when the number has more than 15 digits. Sheets cannot store that many digits as a number. Convert the cells to Plain text format and re-enter the full value, or paste it from a text editor. Do not rely on number format for these cases.

Formatting works on one sheet but not another? Check that you are editing the correct sheet tab. Also, if the data was imported, it may be stored as text already; in that case, go to Format > Number > Number to convert it, or use Data > Split text to columns if it is in a single cell.

Scientific notation appears after a formula calculates? Wrap the formula result with =TEXT(your_formula, "0") to force a full number display. For example, =TEXT(A1*B1, "0") shows the product without an exponent.

Frequently Asked Questions

Why does Google Sheets automatically use scientific notation? It is a default display setting for very large (over 11 digits) or very small (less than 0.000001) numbers to save space. The underlying value is not changed, only how it is shown.

Can I turn off scientific notation for the entire spreadsheet at once? Yes. Click the rectangle at the top-left corner of the sheet (where row numbers and column letters meet) to select all cells, then apply Format > Number > Number. This sets the default for every cell, though new cells may still inherit the sheet default unless you also change it in File > Settings > General (the “Locale” setting can affect formatting).

Does changing the format affect the actual number or calculations? No. Formatting only changes the display. The underlying value remains the same, and formulas referencing the cell will use the full precision stored value.

What is the maximum number of digits Google Sheets can display? Sheets supports up to 15 significant digits for numbers. Beyond that, it rounds. To display more digits accurately, you must store the value as text, which cannot be used in arithmetic directly.

Will the scientific notation come back if I reopen the file? It should not, as long as the format is saved with the sheet. If it reappears, the cell may have been formatted as Automatic or the data was re-entered as a number after formatting.

Can I use a formula to convert scientific notation to text? Yes. Use =TEXT(A1, "0") to convert the number in A1 to a text string with no decimals. For more precision, use =TEXT(A1, "0.############") to show up to 12 decimal places.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →