Excel Cell Shows e+? Fix Scientific Notation

Errors & fixes · Updated November 22, 2026

When an Excel cell shows a value like 1.23E+07, it means Excel has automatically switched the number to scientific notation because the column is too narrow to display the full number. The fix is simple: widen the column, or change the number format to Number or Text.

Why Excel Displays e+ (Scientific Notation)

Excel uses scientific notation (also called exponential format) when a number is too large or too small to fit within the current column width. The “E+” stands for “exponent of 10.” For example, 1.23E+07 means 1.23 multiplied by 10 to the 7th power, which equals 12,300,000. Excel automatically applies this format for numbers with more than 11 digits when the column is at its default width. This is not an error—it’s a display choice, and the underlying value remains intact.

How to Stop Excel From Showing e+

You have three main ways to see the full number instead of the e+ notation. Choose based on whether you want the number to remain numeric or become text.

  • Widen the column: Drag the right edge of the column header, or double-click it to auto-fit. This often resolves the display for numbers up to 11 digits.
  • Apply Number format: Select the cells, go to Home > Number Format dropdown, and choose Number. Increase decimal places if needed.
  • Format as Text: For very long numbers (like credit card numbers or IDs), select the cells, go to Home > Number Format and choose Text. This forces Excel to treat the entry as text, so it won’t convert to scientific notation.

If you already have a column of e+ values, select the range, then apply the Number format. The full numbers will appear immediately.

How to Enter Long Numbers Without e+ (e.g., 16-Digit Credit Cards)

Excel’s precision limit is 15 digits. Any number longer than 15 digits gets rounded to 15 significant digits, and the rest become zeros. For example, entering 123456789012345678 will display as 1.23457E+17 and the stored value becomes 123456789012345000 if you keep it numeric. To preserve the exact digits, you must format the cell as Text before typing the number. Steps:

  1. Select the cell or range.
  2. Go to Home > Number Format and choose Text.
  3. Type the number. It will appear exactly as entered, with no e+.

Alternatively, type an apostrophe (') before the number, like '123456789012345678. The apostrophe is not displayed and forces text format.

How to Convert e+ Values Back to Full Numbers

If you already have a column of scientific notation values and want to see them as regular numbers, follow these steps:

  1. Select the cells with e+ values.
  2. Press Ctrl+1 (Windows) or Cmd+1 (Mac) to open Format Cells.
  3. Go to the Number tab, choose Number, and set decimal places to 0 (or as needed).
  4. Click OK. The cells now show the full number, but note that any digits beyond 15 significant figures were already lost.

For numbers that are purely text (like product codes), you may need to use the Text to Columns feature: select the column, go to Data > Text to Columns, choose Delimited, then on the last step choose Text as the column data format. This forces the values to stay text.

Common Problems and Misconceptions

Many users think the e+ means the number is corrupted or that Excel made an error. It’s not—it’s just a display format. Another common issue is that copying an e+ value and pasting it elsewhere may result in the text version (like “1.23E+07”) instead of the numeric value. To avoid this, copy the cell, then use Paste Special > Values after formatting the destination as Number. Also, when importing CSV files with long numbers, Excel automatically converts them to scientific notation. To prevent this, use Data > From Text/CSV and choose the column format as Text during the import wizard.

How to Keep Numbers as Text in Excel

If you frequently work with IDs, phone numbers, or zip codes, set the cell format to Text before entering data. You can also change the default behavior for the entire column by selecting the column, then applying Text format. For new data entry, remember that any number you type after formatting as Text will be treated as text, so you won’t see e+ or lose leading zeros. For example, entering 00123 in a Text-formatted cell displays as 00123, not 123.

Frequently Asked Questions

Q: How do I remove E+ in Excel without changing the number?
A: Select the cells, press Ctrl+1, choose Number format, and set decimal places. The full number appears, but if it has more than 15 digits, the extra digits are already lost.

Q: Why does Excel show 2.5E+07 instead of 25000000?
A: This is scientific notation. Widen the column or apply Number format. The value 2.5E+07 equals 25,000,000.

Q: How do I stop Excel from converting long numbers to scientific notation when typing?
A: Format the cell as Text before typing, or type an apostrophe before the number. For a whole column, select it and set format to Text.

Q: Can I convert scientific notation back to a normal number if it’s already in the cell?
A: Yes, use Format Cells > Number. But if the number has more than 15 digits, the precision is already reduced.

Q: Why does Excel round my 16-digit credit card number?
A: Excel’s numeric precision is limited to 15 significant digits. To keep the full number, format as Text before entering it.

Q: Is there a way to make Excel display all numbers normally by default?
A: No, but you can set a custom default format for new workbooks by changing the Normal style font or using a template. For quick fixes, use the Number format on selected cells.

Excel for Mac and Web Differences

On Excel for Mac, the same steps apply: use Format > Cells or press Cmd+1. The ribbon path is Home > Number Format as well. In Excel for the web, the Number Format dropdown is under Home > Number Format, and you can also use the Format Cells dialog by right-clicking and choosing Format Cells. The scientific notation behavior is identical across platforms.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.