ShortcutdrillExcel shortcuts / formatting / Thousands separators and two decimals
Thousands separators and two decimals in Excel: Ctrl+Shift+1 (Mac: Control+Shift+1)
| Windows | Ctrl+Shift+1 |
|---|---|
| Mac | Control+Shift+1 |
| Group | formatting |
Drill: Thousands separators. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Shift+1 (Ctrl+!) applies the number format with two decimals and a thousands separator, the standard look for amounts in a report. It is the format most models use instead of currency symbols.
The common mistake
Applying it to a count or a year, which then shows as 2,026.00.
Related shortcuts
- Italic Ctrl+I
- Underline Ctrl+U
- Format as currency Ctrl+Shift+4
- Format as percentage Ctrl+Shift+5
- Format a serial number as a date Ctrl+Shift+3
- The printable cheat sheet
Questions
How do I get thousands separators without decimals?
Ctrl+Shift+1 then Alt, H, 9 twice to remove the decimals, or set the format #,##0 in Format Cells (Ctrl+1).
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill