How to Convert Exponential to Number in Excel: A Guide

How-to basics · Updated November 20, 2026

To show an Excel value written in scientific notation as an ordinary number, select the cells and choose Home > Number Format > Number; widen the column if needed. This changes how a numeric value appears, not the value itself. If the notation is stored as text, convert it with a formula such as =VALUE(A2) or use Text to Columns. First check which case you have, because changing a display format will not turn text into a number.

Scientific notation is a compact way to write very large or very small numbers. For example, 6.02E+05 represents 602,000, and 3.5E-04 represents 0.00035. Excel may display this notation automatically when a cell uses General formatting, when a column is too narrow, or when imported data is text. The right method depends on whether you want a different display, a numeric value from text, or to preserve a long identifier exactly.

What You’ll Need

  • Excel for Microsoft 365 on Windows and the worksheet containing the values.
  • A spare column or a copy of the data if you are converting text or imported values. This makes it easier to compare the results and undo a mistaken conversion.
  • For long codes or identifiers, the original source file or data. Excel keeps up to 15 significant digits in numeric values, so formatting cannot restore digits that were already rounded or dropped.

Step-by-Step

  1. Check whether the cell contains a number or text. Click a sample cell and look at the formula bar. A numeric value may appear there in exponential notation even if the cell itself is formatted to show a different style. A text value may be left-aligned by default, show a small green warning indicator, or fail to behave like a number in calculations. Alignment is only a clue, not proof: cells can be manually aligned. You can also test a sample in an empty cell. With the value in A2, enter =ISNUMBER(A2); TRUE means A2 contains a number, while FALSE means it is not stored as a numeric value. This test is optional, but it helps you choose the right approach.
  2. Change the display for values that are already numeric. Select the cells, then go to Home > Number Format and choose Number. Excel will usually stop using scientific notation for ordinary-sized values. Set the decimal places with the increase or decrease decimal buttons on the Home tab, or open the Format Cells dialog with Ctrl+1 on Windows and choose the Number category. On Mac, Command+1 opens Format Cells in current Excel versions; you can also use the Home tab controls. Choose the decimal places you actually need, because displaying fewer places can hide decimals without changing the underlying value. If you need to see the exact value in calculations, inspect the formula bar rather than relying only on the rounded display.
  3. Make sure the column is wide enough. A narrow column can show scientific notation or a row of number signs even after you apply Number format. Double-click the right edge of the column letter to AutoFit the width, or use Home > Format > AutoFit Column Width. You can also drag the boundary wider. This adjusts the visible space, not the cell value. If you need a compact display, choose an appropriate number format instead of shrinking the column until the contents are hard to read.
  4. Use a custom format if you want a specific appearance. Select the numeric cells, press Ctrl+1 on Windows (Command+1 on Mac), choose Custom, and enter a format such as 0 for whole numbers or 0.00 for two decimal places. Click OK. For instance, a numeric value of 602000 shown with format 0 appears as 602000; a value of 0.00035 shown with 0.00 appears as 0.00 because the format rounds the display to two decimal places. Pick enough decimal places to make the displayed result useful. A custom format changes presentation only; it does not convert text to a number or increase Excel’s precision.
  5. Convert text notation with a formula when you need a numeric result. If the text 6.02E+05 is in A2, enter =VALUE(A2) in B2. Excel returns the number 602000. Fill the formula down for the other rows, then check several results before using them. The formula uses the cell reference A2, so change that reference to match your first source cell. If your text includes extra spaces, you may need to remove them first; if it contains a decimal separator or exponent format that does not match your Excel regional settings, VALUE may not interpret it as expected. Keep the source column until you have verified the converted results.
  6. Convert a whole text column with Text to Columns. Make a copy of the source column, select the copied cells, then choose Data > Text to Columns. Select Delimited and click Next, leave the delimiter choices unchanged if each cell is already a complete value, and click Next. In the column data format options, select General, then click Finish. Excel attempts to interpret entries such as 6.02E+05 as numbers. Apply Number format and widen the column afterward if Excel still displays scientific notation. The wizard can convert other text fields too, so use it on a copy and confirm the preview and resulting values before replacing the original data.
  7. Keep long identifiers as text instead of converting them. If a value is an account code, tracking number, product ID, or another identifier with more than 15 significant digits, it is not safe to treat it as an ordinary number. Set the destination column to Text before importing or pasting, or use the import options to designate that column as text. Numeric conversion can alter trailing digits, and changing the format afterward cannot recover them. For a value that must be used in arithmetic, check the original source and decide whether Excel’s numeric precision is sufficient before converting.

Common Mistakes

Assuming scientific notation means the value changed. A cell displaying 1.2E+06 may still contain the numeric value 1,200,000. Changing the format usually reveals the ordinary display without changing that value. Use the formula bar or a number-format change to check before converting anything.

Applying Number format to text. Number formatting affects numeric cells, but text that looks like 1.2E+06 remains text. Use VALUE or Text to Columns to convert it, then format the resulting number if needed.

Relying on visible digits for a long number. Excel’s numeric precision is limited to 15 significant digits. A 16-digit or longer identifier may be changed during entry or import. A custom format, wider column, or formula cannot restore the original digits after that has happened.

Confusing display rounding with conversion. If you select two decimal places, Excel may show 12.35 for a stored value of 12.345. That is a display choice; the stored value can retain more decimal places. If you need to permanently round calculations, that is a separate operation and should be done intentionally.

Overwriting the source too soon. Formulas and Text to Columns can produce results you did not expect if the data has spaces, unusual separators, or mixed types. Keep a backup column or duplicate the worksheet until you have checked representative rows, including the largest and smallest values.

Tips

  • Decide whether your goal is to change appearance or data type. Use Number or a custom format for numeric values; use VALUE or Text to Columns when the cell contains text.
  • For a list of measurements, choose decimal places that reflect the source precision. Showing a very small value with zero decimal places can make it appear to be zero, even though it is not.
  • After converting a text column, test a result with =ISNUMBER(B2) when the converted value is in B2. TRUE confirms that Excel sees it as a number; it does not verify that every digit is correct, so compare against the original source too.
  • Use a helper column for formulas, then copy the checked results and choose Paste Special > Values if you want to replace formulas with fixed numeric results. Retain the original data until the workbook is complete.
  • If you only need to inspect a number temporarily, select the cell and read the formula bar. Changing the worksheet format is not necessary just to see the underlying value there.

Troubleshooting

The cell still shows E notation after choosing Number: AutoFit the column, set a suitable number of decimal places, and check whether the entry is text. If the value is extremely large or small, scientific notation may be a more readable display. A custom format can request a standard appearance, but it cannot make an impractically long value fit in a narrow cell.

VALUE returns an error: Check for leading or trailing spaces, hidden characters copied from a website, or a decimal and thousands separator that differs from your Excel regional settings. Try retyping one sample into a clean cell. If the source includes nonbreaking spaces or other imported characters, clean the text before conversion, and preserve the original while you test.

Text to Columns produces unexpected fields: In the wizard, verify that Delimited is selected and that no delimiter is checked when each cell should remain intact. Review the preview before clicking Finish. Run the wizard on a duplicate column so an incorrect delimiter choice does not overwrite the source.

The result has changed digits or ends in zeros: If the value contains more than 15 significant digits, Excel may have rounded it when it was first entered or imported as a number. Reimport it from the original source with the column set to Text. Formatting cannot reverse precision loss. If the value is shorter, compare the formula bar and source; a chosen decimal-place format may only be hiding digits from view.

A formula displays scientific notation too: The formula can return a correct number while the result cell is formatted as General. Apply Number format and AutoFit the output column. Check that the formula result is numeric with ISNUMBER if you are unsure.

Frequently Asked Questions

Does scientific notation mean Excel changed my number?

Not necessarily. It often means Excel is choosing a compact way to display a numeric value. Apply Number format or widen the column to check its ordinary display. If the value was imported or typed as text, it needs conversion separately.

How do I convert 1.23E+05 to a regular number?

If the cell already contains a number, select it and choose Number from Home > Number Format; 1.23E+05 represents 123000. If A2 contains the characters as text, enter =VALUE(A2) in another cell to return the numeric value 123000.

Can I remove E notation without changing the value?

Yes. For a numeric value, change its number format and adjust the column width. Formatting changes how Excel displays the value, not the stored numeric value. Be aware that choosing too few decimal places can hide part of the value on screen.

Why does a very long number lose digits in Excel?

Excel stores only 15 significant digits for numeric values. Long IDs and codes should be imported or entered as text if every digit must remain unchanged. Changing a cell to Text after Excel has already rounded the number does not recover the missing digits.

Will changing to Number make a text value usable in calculations?

Changing the format alone will not. Convert text with VALUE or Text to Columns, then verify that Excel recognizes the result as numeric. Also check that the conversion interpreted decimal and exponent characters as intended.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.