Most valuable professional
  • Excel Book Excerpt

Excel Better Scientific Notation

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

Better Scientific Notation

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.

LE10001209.jpg 

Figure 1167 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.

LE10001210.jpg 

Figure 1168 Column E

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: