In Excel for Microsoft 365 on Windows, an engineering number format is a custom scientific format that puts the exponent in multiples of three. Select the cells, press Ctrl+1, choose Number > Custom, and enter ##0.00E+00; for example, 12,345 displays as 12.35E+03 while the stored value remains 12,345.
What engineering notation means
Engineering notation writes a number as a mantissa multiplied by a power of ten, with the exponent restricted to a multiple of three. The mantissa is usually from 1 up to, but not including, 1,000. For instance, 12,345 is 12.345 × 10³, while 0.000012345 is 12.345 × 10⁻⁶. The multiple-of-three rule distinguishes engineering notation from ordinary scientific notation, which commonly keeps one digit before the decimal point and can use any integer exponent.
This pattern is useful in fields where quantities are commonly grouped by powers of a thousand. SI prefixes follow the same pattern at many scales: kilo represents 10³, mega 10⁶, milli 10⁻³, and micro 10⁻⁶. An engineer might describe a measurement as 12.35 kV rather than 1.235 × 10⁴ V. Excel’s number format can show the exponent, but it does not automatically add the correct SI prefix or unit. Those are separate presentation choices.
How the Excel format code works
The code ##0.00E+00 combines three parts. The hashes and zero before the decimal point allow the mantissa to use up to three digits before the decimal; the two zeros after the decimal request two displayed decimal places; and E+00 displays an exponent with a sign for positive powers and at least two exponent digits. Excel’s scientific-format rules use the extra integer placeholders to allow engineering-style exponents in steps of three.
In the displayed result, E means “times ten to the power of,” not a variable in the original value. Thus 12.35E+03 means 12.35 × 10³. A negative exponent is shown with a minus sign, such as 12.35E-06. The format code controls how Excel presents a numeric value; it does not convert the value to text, multiply or divide the underlying number, or change calculations that refer to the cell.
In the code, the zero before the decimal is a required digit placeholder, while each hash is an optional digit placeholder. The decimal places are rounded for display, not deleted from the stored number. If you need more precision visible, add zeros after the decimal point, as in ##0.0000E+00. If you prefer one decimal place, use ##0.0E+00.
Apply the format in Excel for Windows
- Select the numeric cells or the whole column you want to format. The cells should contain numbers, not text that merely looks numeric.
- Press Ctrl+1 to open Format Cells. Alternatively, on the Home tab, open the Number group’s dialog launcher.
- Select the Number tab, choose Custom in the Category list, and click the Type box.
- Enter
##0.00E+00and select OK. Check a large, small, positive, and negative value if the column contains a wide range.
To format only a few cells differently, select those cells before opening the dialog. You can also copy the format with Format Painter or use Paste Special > Formats, taking care not to overwrite the destination values. On Excel for Mac, select the cells and press Command+1 to open Format Cells; the Custom category and Type field are used there as well. Excel for the web can display many formats already applied in a workbook, but creating or editing a custom format may require opening the workbook in the desktop app, depending on the available web controls.
Examples and how to read the results
With the two-decimal format, the following are representative displays. The decimal digits shown are rounded, and the original cell values remain available for formulas and charts.
- 12,345 displays as 12.35E+03, which reads as 12.35 × 10³.
- 1,234,567 displays as 1.23E+06, which reads as 1.23 × 10⁶.
- 0.000012345 displays as 12.35E-06, which reads as 12.35 × 10⁻⁶.
- -12,345 displays with a leading minus sign, for example -12.35E+03.
The final displayed digits depend on rounding to the requested decimal places. For example, a value with more than two decimal places in its mantissa can appear slightly different from the exact value when read from the screen. Increase the number of decimal placeholders when the distinction matters. A format affects cell display, not the number used in arithmetic: if a result needs to be rounded mathematically, use a suitable calculation rather than relying on a display format.
Choose precision and a readable layout
Choose the number of displayed decimals based on the precision readers need, not simply on how many digits the source data contains. A measurement recorded to three significant figures may be misleading if the spreadsheet displays six. Conversely, two decimal places may hide differences important in a high-precision calculation. For a report, a consistent format across comparable measurements makes columns easier to scan.
- Use
##0.0E+00for a compact view with one decimal place. - Use
##0.00E+00as a general two-decimal display. - Use
##0.000E+00when three decimal places are useful. - Keep units in a heading or a separate column, such as Voltage (V), rather than assuming the E notation supplies a unit.
A column can include values that differ by many orders of magnitude. Engineering notation makes their scale visible while keeping the mantissa in a consistent range. But if all values are ordinary-sized and readers need to compare exact whole numbers, standard number formats may be easier to interpret. Formatting is a communication choice as well as a technical one.
Engineering format versus Excel’s scientific format
Excel’s built-in Scientific category is designed for scientific notation and typically displays one digit before the decimal point, such as 1.23E+04. The custom engineering-style code allows up to three digits before the decimal, giving 12.30E+03 for the same scale of number. Both are numeric displays, and neither changes the underlying value. You can select Scientific from Format Cells when ordinary scientific notation is what you need; use a custom format when the exponent grouping is important.
Engineering notation can also be written with SI prefixes, such as 12.3 k instead of 12.3E+03 for a quantity measured in base units. Excel does not infer whether a value represents volts, seconds, or another unit, so it cannot safely choose a prefix on its own. A fixed format that appends a letter may also be wrong for cells with different scales. If a report must show prefixes, design and verify that display separately, including how it handles values outside the chosen range.
Common problems and limitations
- The exponent is not a multiple of three: Check that the custom code has up to three integer placeholders before the decimal, as in
##0.00E+00, rather than a single required zero such as0.00E+00. - The cell shows the code instead of a number: Confirm that the code was entered in Format Cells > Number > Custom, not typed into the worksheet cell. Also check that the cell contains a numeric value.
- The display seems less precise: Excel rounds the visible mantissa to the number of decimal places in the code. Add decimal placeholders if needed; the stored value has not been rounded by applying the format.
- A formula or import treats the result as text: A cell’s displayed appearance is not the same as its stored value. Check whether the source itself was imported as text before changing the number format.
Custom formats are not a substitute for data conversion. If an imported value is text, applying a numeric format does not necessarily turn it into a number. Similarly, a chart or exported file may use its own labels or formatting rules. Inspect the underlying value and the output destination when a number appears differently outside the worksheet.
When another display is a better choice
Use standard scientific notation if a one-digit mantissa is familiar to your audience or matches a scientific publication’s convention. Use ordinary decimal formatting when the scale is modest and the exact magnitude is immediately readable. For a technical report that needs both convenient comparison and units, keep the numeric value in one column and the unit in a clearly labeled heading or adjacent column.
For calculations requiring a converted unit, calculate or store the converted numeric value separately; do not treat a visual format as a conversion. Keeping values numeric also preserves sorting, charting, and arithmetic behavior. If you need to show a textual expression such as “12.35 × 10³,” remember that a number format’s E notation is a compact display convention, not a literal multiplication sign and superscript exponent.
Frequently Asked Questions
Does Excel have a built-in Engineering number category?
Excel provides a Scientific category, but engineering-style display is commonly set up with a custom number format such as ##0.00E+00. The custom format keeps the value numeric while displaying exponents in groups of three.
Does applying engineering format change the value?
No. It changes how the number appears in the cell. Excel continues to use the original numeric value in calculations, although the displayed mantissa may be rounded.
How do I show more digits?
In Format Cells > Number > Custom, add zeros after the decimal point in the format code. For example, ##0.000E+00 displays three decimal places in the mantissa.
Why does Excel show E+03 instead of × 10³?
E notation is Excel’s compact way to display a power of ten. E+03 means multiplication by 10³. A normal number format does not automatically render the multiplication sign and superscript typography.
Can I add units such as volts to the format?
You can add literal text to some custom formats, but a fixed unit is appropriate only when every cell represents that same unit. For clear, reliable tables, putting the unit in a column heading or separate column avoids implying that Excel has converted the measurement.
Related
- Excel Dependent Drop-Down List: 3 Levels
- Excel Dependent Drop-Down Lists with Dynamic Ranges
- Excel Dependent Drop-Down Lists in Tables
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation Colour Change: Rules and OptionsExcel data validation cannot change a cell’s colour by itself. To colour cells according to a validated value—or…
- Excel Circular Reference Warning: Causes and FixesAn Excel circular reference warning means a formula refers to its own cell, either directly or through a…
- How to Clear the Outlook Cache in File ExplorerTo clear Outlook’s local autocomplete cache in File Explorer, close classic Outlook, enter %LOCALAPPDATA%\Microsoft\Outlook\RoamCache in File Explorer’s address…
- How to Share a Group Calendar in New OutlookTo share a group calendar in New Outlook, add the people who need access as members of its…
- Can You Copy an Excel Spreadsheet? Methods ExplainedYes. In Excel for Microsoft 365 on Windows, make a separate copy of an entire spreadsheet with File…
- Excel Date Format Shortcut: Change Dates in SecondsTo change selected cells to Excel’s standard date display in Microsoft Excel for Microsoft 365 on Windows, select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.