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.
- 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.
- Column E