Shortcut for number format in Excel
If you want to add a delimiter to a number entered in a cell, or display it to two decimal places, you can apply a number format to the cell. To apply numeric formatting to a cell, you need to select tools from the ribbon, or display the Format Cells dialog box and select format. However, if you use the shortcut keys shown below, you can apply a number format without taking your hands off the keyboard.
Number format shortcut
Ctrl + Shift + 1
command + shift + 1 or control + shift + 1
How to apply number formatting to cells
We will show you how to apply number formatting to cells using the shortcut keys.
Total Time: 1 minute
Select a cell
Select the cells to which you want to apply the number format.
Number format applied
Press Ctrl + Shift + 1 to apply the number format.