Format Numbers with Two Decimal Places and Commas for Thousands

Master this Excel shortcut with our comprehensive guide

Formatting Shortcuts Ctrl + Shift + ! ⌘ + Shift + !

How to Use This Shortcut

Keyboard Shortcut
Ctrl + Shift + !
Instructions
1. Select numeric cells
2. Press Ctrl + Shift + ! to apply standard number format with commas
Keyboard Shortcut
⌘ + Shift + !
Instructions
1. Highlight numeric cells
2. Press Command + Shift + ! for comma-separated numbers with 2 decimals
💡 Pro Tip: Ensures data is readable and professionally formatted for reports.
More Formatting Shortcuts