Display numbers with scientific notation
- Select the cells you want to format.
- On the Format menu, click Cells, and then click the Number tab.
-
In the Category list, click Scientific. In the Decimal places box, enter the number of decimal places you want to display.