Formats the selected cells as numbers with two decimal places and a thousands separator, so 1234.5 shows as 1,234.50. It is the quickest way to tidy up a column of amounts. Google Sheets uses the same keys.
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
- Add an outline borderCtrl+Shift+7
- Apply the percent formatCtrl+Shift+5
- Apply the Scientific formatCtrl+Shift+6
- Apply strikethroughCtrl+5
- Apply the Time formatCtrl+Shift+2
- Ungroup rows or columnsAlt+Shift+Left
- Unhide rowsCtrl+Shift+9