Excel Number in Scientific Notation: How to Fix It

Errors & fixes · Updated November 19, 2026

To stop Excel from displaying a value in scientific notation, widen the column or select the cells and choose Home > Number Format > Number; for an identifier or a value longer than 15 digits, set the cells to Text before entering or importing it. A display change can fix how a number looks, but it cannot restore digits Excel has already changed or discarded.

Fix the display quickly

Excel uses the General format by default. If a number does not fit comfortably in a cell, or is large enough for General formatting to abbreviate it, Excel may show it in scientific notation. For example, a value may appear as 1.23457E+12. That is a compact display of a number, not necessarily a different value.

For ordinary numbers that have 15 or fewer significant digits, try these steps in Excel for Microsoft 365 on Windows:

  1. Select the affected cells or the whole column.
  2. On the Home tab, open the Number Format dropdown in the Number group and choose Number.
  3. If you need an integer display, use the decimal-place controls on the ribbon to show zero decimal places.
  4. Widen the column if the full value still does not fit. Drag the right edge of the column heading, or double-click that edge to AutoFit the column.

You can also press Ctrl+1 to open Format Cells, choose the Number tab, select Number, set Decimal places to 0 if appropriate, and select OK. On a Mac, Command+1 opens Format Cells; the ribbon’s number-format controls are also available. If the cell is explicitly set to Scientific, changing it to Number or General usually removes that format.

Why Excel switches to scientific notation

Scientific notation expresses a number as a value multiplied by a power of ten. In 1.23457E+12, the E+12 means move the decimal point 12 places to the right: the displayed value is approximately 1,234,570,000,000. Excel uses this compact form in some situations because a worksheet cell has limited width and General formatting adapts to the contents.

There is no single digit count that guarantees a number will look scientific in every worksheet. Column width, the number’s size, and its number format all matter. A long value might show normally in a wide cell and switch to scientific notation in a narrow one. Conversely, scientific notation may be an intentional format applied to a cell even when there is room to display the number another way.

To check the format, select a cell and look at the Number Format dropdown on the Home tab. If it says Scientific, choose another format. If it says General, widen the column or choose Number. Seeing E in the cell is a clue, but it does not tell you whether the underlying value has been preserved accurately.

Display format is not the same as stored value

Number formatting changes how Excel displays a value; it does not normally change the underlying numeric value. Widening a column, choosing Number, or applying a custom display format can reveal more of a value that is still stored accurately. But Excel has a significant precision limit: it keeps no more than 15 significant digits in a numeric value.

For instance, if you enter the 16-digit integer 1234567890123456 as a number, Excel cannot preserve all 16 digits. Digits beyond its 15-digit precision limit may be replaced with zeros. Changing the cell to Text afterward will not bring the original ending digit back. If the exact value matters, retrieve it from the original source and import or enter it as text.

Also distinguish rounding in the display from loss in the stored value. A cell might show fewer decimal places because of its format while retaining more precision internally. Increase the displayed decimal places or inspect the formula bar to see more, but remember that neither action can recover digits beyond Excel’s numeric precision limit.

Change values that are already in the worksheet

If a value is still accurate and has no more than 15 significant digits, changing the format is usually enough. Select the cells, choose Number or a suitable custom format, and widen the column. For a long number that Excel has already altered, use the original data and re-enter or reimport it as text instead of trying to repair the displayed value.

When you need an existing column treated as text, you can use the Text to Columns wizard, then check the results carefully. Select the column, choose Data > Text to Columns, proceed through the wizard, and at the final step set Column data format to Text before choosing Finish. This can convert current cell contents to text, but it cannot reconstruct digits that were lost when the numbers were first entered.

Another option for short, accurate values is to create a text copy in a new column. With the value in A1, enter =A1&"" in another cell. This returns the value as text, but only from the value currently stored in A1; it does not restore missing digits or leading zeros. Check the result before replacing or deleting the original column.

Prevent the problem when entering or importing data

For data you type or paste, format the destination cells as Text first: select them, choose Home > Number Format > Text, then enter or paste the values. This matters most for long digit strings, codes, and values with leading zeros. As a one-off alternative, type an apostrophe before a value, such as '001234567890123456. Excel uses the apostrophe to treat the entry as text; it is not part of the cell’s displayed value.

Be especially cautious with CSV files. Opening a CSV by double-clicking it can lead Excel to interpret digit strings as numbers, which may remove leading zeros or alter long values. In Excel for Microsoft 365 on Windows, use Data > From Text/CSV to import the file. In the Power Query preview, select the relevant column and set its data type to Text before loading it, then choose Home > Close & Load. Check the imported column against the source file, especially if exact identifiers matter.

Excel for the web can display and edit text-formatted cells, but the desktop import workflow may differ or may not be available in the same way. If the source is a CSV containing long identifiers, importing it through desktop Excel with the column explicitly set to Text is a dependable way to control interpretation. Avoid relying on a visual fix after data has already been converted.

Numbers, codes, and leading zeros

A useful rule is to ask whether the value represents a quantity or merely labels something. Quantities such as a measurement or a total are usually numbers: you may want to add them, average them, or use them in calculations. Account numbers, tracking codes, product IDs, postal codes, and long reference numbers are generally identifiers. Even if they contain only digits, arithmetic on them is not meaningful, so storing them as text is usually safer.

For example, a postal code such as 02138 is not the number 2,138; the leading zero is part of its identity. If Excel stores it numerically, that zero may disappear. A custom number format such as 00000 can make a five-digit numeric value display with leading zeros, but the underlying value remains numeric. Text is preferable when the exact original characters must be retained or the length varies.

Likewise, a custom format such as 0 can display an ordinary integer without scientific notation if the number is within Excel’s precision limit and the column is wide enough. It is not a solution for a 16-digit card or account number: formatting cannot make Excel store extra numeric precision. For identifiers, preserve the source characters as text.

Common problems and how to diagnose them

  • Changing the format appears to do nothing: The column may be too narrow, or the cell may contain a text string rather than a number. Widen the column and check the Number Format dropdown. Text is often left-aligned by default, but alignment can be changed, so alignment alone is not a reliable test.
  • The ending digits are now zeros: If a long entry was stored as a number, Excel may already have exceeded its 15-digit precision limit. Changing the format will not restore the original digits. Reimport the value as text from the source.
  • Leading zeros vanished: Excel interpreted the entry as a number. Reimport or re-enter it as text, or use a fixed-width display format only if you intentionally want a numeric value shown with a consistent number of digits.
  • Only some cells show scientific notation: They may have different formats, different widths in a merged or adjacent layout, or different underlying types. Select each affected cell and inspect its format and formula bar rather than applying a broad change without checking.
  • The value looks rounded: Increase displayed decimal places if it is a decimal measurement. If the original digits came from a long identifier, do not treat rounding controls as a repair; confirm the full text against the source.

Frequently Asked Questions

How do I stop Excel from changing numbers to E+ notation?
Select the cells and choose Number or widen the column if you only need a different display. If the entry is a long identifier, format the cells as Text before entering or importing it.

Does scientific notation mean Excel changed my number?
Not necessarily. It may be only a compact display of the stored value. However, numeric entries are limited to 15 significant digits, so a value with more digits may already have been altered. Check the source when exact digits matter.

How do I keep all digits in a 16-digit number?
Store it as text before Excel interprets it as a number. Set the destination column to Text before typing or importing, or import a CSV through Data > From Text/CSV and assign the column the Text type. Formatting a previously rounded number cannot recover the missing digit.

Can I remove scientific notation without changing the value?
Usually, yes, for an accurately stored number with 15 or fewer significant digits: choose Number or General and widen the column. This changes the display, not the underlying number. It cannot overcome Excel’s precision limit.

Why did Excel remove the zeros at the start?
Excel treated the entry as a number, and leading zeros are not significant in ordinary numeric values. Use Text format for codes that need those zeros, or use a fixed-width custom format when you specifically want a numeric value displayed at a consistent length.

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.