Excel: Better Scientific Notation

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I have to enter values for milliamps. For the 35 mA in row 2, you type 35E-3. For the 150 mA in row 3, you type 150E-3. In both cases, Excel changes what you typed to the values shown in column C.

  1. If you look quickly, the 1.5 appears smaller than 3.5.

    Format the cells using Ctrl+1. Choose the Number tab and then the Custom category. Change the custom format code from 0.00E+00 to ##0.0E+00.Excel will now display the cells as you wish.

  2. Column E