Formatting Issues

How to Use Engineering Notation with Exponents in Multiples of Three in Excel

Maira Mehtab Sep 20, 2026 869 views

Question details

The user wants to format numerical data in Excel so that scientific notation uses engineering exponents that are strict multiples of three (e.g., 1E-06, 1E-09) rather than standard notation.

Product: Excel
Device & OS: not provided
Scenario: Formatting numbers for engineering or scientific reporting where exponents need to align with standard metric prefixes (kilo, micro, nano, etc.).
Observed behavior: By default, standard scientific notation may use exponents that are not multiples of three, such as E-04 or E11, which requires a custom formatting adjustment.

Before you start

Highlight all the cells containing the numerical data you wish to convert to engineering notation before opening the formatting dialog.

Solution 1Recommended

Apply a Custom Engineering Notation Format

Use a custom number format starting with ##0 to force Excel to group exponents by multiples of three.

To achieve true engineering notation in Excel, you must utilize the Custom number formatting feature. Standard scientific formatting often produces exponents like E-04 or E-05, but adding a double hash and a zero (##0) before the decimal forces the exponent to snap to a multiple of three.

Select Target Cells

Click and drag to highlight the cells that contain the values you want to format.

Open the Format Cells Dialog

Right-click the selected cells and choose 'Format Cells' from the context menu, or simply press 'Ctrl + 1' on your keyboard.

Navigate to Custom Categories

In the Format Cells dialog box, go to the 'Number' tab and click on 'Custom' at the bottom of the Category list.

Enter the Engineering Format Code

In the 'Type' input box, enter '##0.0E+0' (or '##0E+0' / '##0.00E+0' depending on how many decimal places you want) and click 'OK' to apply the formatting.

Format Variation: The number of zeros placed after the decimal point in your custom code will determine exactly how many decimal places are displayed in the final output.

WPS Spreadsheet Formatting

Format Engineering Notation Easily in WPS Spreadsheet

WPS Spreadsheet fully supports advanced custom number formatting, making it simple to apply engineering notation with exponents in multiples of three, just like Microsoft Excel.

1. Select your data: Open your document in WPS Spreadsheet and select the cells containing the numbers you want to format.
2. Open Format Cells: Press 'Ctrl + 1' or right-click your selection and choose 'Format Cells'.
3. Choose Custom Formatting: Navigate to the 'Number' tab and select the 'Custom' category.
4. Apply Engineering Notation: Type '##0.0E+0' into the Type field and click 'OK' to instantly format your data.

Fully compatible with Microsoft Excel custom number formatsQuickly format large datasets for scientific and engineering calculationsFree, lightweight, and highly responsive spreadsheet processing

microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between scientific and engineering notation in Excel?

Scientific notation typically places a single non-zero digit before the decimal point (e.g., 1.2E+04), whereas engineering notation adjusts the decimal place to ensure the exponent is strictly a multiple of three (e.g., 12E+03), aligning with metric prefixes like kilo or micro.

How do I change the number of decimal places in the engineering format?

You can change the decimal places by modifying the custom format code in the Format Cells dialog. Simply add or remove zeros after the decimal point in your string (for example, use '##0.000E+0' for three decimal places).

Does applying a custom format change the actual value of the cell?

No, applying a custom number format only changes how the number is displayed visually on your screen or when printed. The underlying numerical value remains completely unchanged for all mathematical calculations.

Document & File Issues