ShortcutdrillExcel shortcuts / formatting / Clear the number format
Clear the number format in Excel: Ctrl+Shift+` (Mac: Control+Shift+~)
| Windows | Ctrl+Shift+` |
|---|---|
| Mac | Control+Shift+~ |
| Group | formatting |
Drill: Clear a number format. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Shift+` (Ctrl+~) sets the General format, which removes currency symbols, separators, percent signs and date formatting and shows the raw value.
The common mistake
Confusing it with Ctrl+` (no Shift), which shows formulas instead of values.
Related shortcuts
- Italic Ctrl+I
- Underline Ctrl+U
- Format as currency Ctrl+Shift+4
- Thousands separators and two decimals Ctrl+Shift+1
- Format as percentage Ctrl+Shift+5
- The printable cheat sheet
Questions
How do I remove a percent format?
Select the cells and press Ctrl+Shift+`. The values stay; only the display changes.
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