

The format will be applied to the selected cell(s). Then press one of the number keys at the top of the keyboard.This might make it easier to use two hands to press the combination.

However, you can also use the Ctrl & Shift keys on the right side of the keyboard. The diagram shows the Ctrl & Shift keys on the left side. Here is a quick guide that explains what each shortcut does. The Ctrl+Shift+Number Key shortcuts allow us to quickly apply some of the most popular number formatting options including: currency, percent, number, date, and time. If you spend a lot of time formatting numbers in Excel (who doesn't?) then you will love these shortcuts. Number-Formatting-Shortcuts-Ctrl-Shift.xlsx Download Number Format Shortcuts Guide
