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
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
2. Press Command + Shift + ! for comma-separated numbers with 2 decimals
💡 Pro Tip: Ensures data is readable and professionally formatted for reports.