Formats the selected cells in scientific notation with two decimal places, so 123456 shows as 1.23E+05. It is useful for very large or very small values. Ctrl+Shift+1 turns it back into an ordinary number.
More Format shortcuts
- Apply the Currency formatCtrl+Shift+4
- Apply the Date formatCtrl+Shift+3
- Open Format CellsCtrl+1
- Group rows or columnsAlt+Shift+Right
- Hide the selected columnsCtrl+0
- Hide the selected rowsCtrl+9
- Apply the Number formatCtrl+Shift+1
- Add an outline borderCtrl+Shift+7
- Apply the percent formatCtrl+Shift+5
- Apply strikethroughCtrl+5
- Apply the Time formatCtrl+Shift+2
- Ungroup rows or columnsAlt+Shift+Left
- Unhide rowsCtrl+Shift+9