Ctrl+Shift+Exclamation Point: Formats Numbers

The shortcut Ctrl+Shift+Exclamation Point (!) is to format numbers with two decimals, thousands separator, and minus sign (-) for negative values, please also check shortcut Ctrl+Shift+1.

Step 1: Select the data you want to format;

Step 2: Press and hold the Ctrl and Shift keys, then press the "Exclamation Point (!)" sign from the keyboard.

Check More Excel Shortcuts

Leave a Reply