Our Service

Custom Formats for Scientific Notation in Excel

Excel is a powerful tool for data analysis, and one of its most useful features is the ability to display numbers in scientific notation. Scientific notation is a way of expressing very large or very small numbers in a more compact form, making it easier to read and understand. In this article, we will explore how to create custom formats for scientific notation in Excel.

Understanding Scientific Notation

Scientific notation is a way of expressing numbers as a coefficient multiplied by a power of 10. For example, the number 3,000,000 can be expressed as 3 x 10^6 in scientific notation. This makes it easier to work with very large or very small numbers, as it eliminates the need for many zeros.

Creating Custom Formats

Excel has a number of built-in formats for displaying numbers in scientific notation, but you may want to create your own custom format to suit your needs. To create a custom format, follow these steps:

Step 1: Select the cell or range of cells you want to format

Click on the cell or range of cells you want to format. You can also select multiple non-adjacent cells by holding down the Ctrl key while clicking on each cell.

Step 2: Open the Format Cells dialog box

Right-click on the selected cells and choose Format Cells from the context menu. Alternatively, you can click on the Home tab of the ribbon, click on the Number dropdown, and choose More Number Formats at the bottom of the list. This will open the Format Cells dialog box.

Step 3: Choose the Custom category

In the Format Cells dialog box, click on the Custom category on the left-hand side. This will display a list of custom formats that you can use as a starting point for your own format.

Step 4: Create your custom format

In the Type field, enter your custom format. To display a number in scientific notation, use the following syntax:


The 0.00 represents the coefficient, and the E+00 represents the power of 10. You can adjust the number of decimal places and the exponent as needed. For example, if you want to display the number with three decimal places and an exponent of 3, you would use the following format:


Step 5: Apply your custom format

Click OK to apply your custom format to the selected cells. The numbers in those cells will now be displayed in scientific notation according to your custom format.


Custom formats for scientific notation can be a powerful tool for displaying large or small numbers in a more readable format. By following the steps outlined in this article, you can create your own custom formats in Excel and make your data analysis more efficient and effective.


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.