How to change number format easily

Excel 365 2013 2010 2007 2003
A simply way to apply number formatting is to use shortcut keys.
This tip summarizes the shortcut-key combinations that you can use to apply common number formatting to the selected cells or range.

Number-Formatting Keyboard Shortcuts

Key Combination Formatting Applied
Ctrl+Shift+~ General number format (that is, unformatted values)
Ctrl+Shift+$ Currency format with two decimal places (negative numbers appear in parentheses)
Ctrl+Shift+% Percentage format, with no decimal places
Ctrl+Shift+^ Scientific notation number format, with two decimal places
Ctrl+Shift+# Date format with the day, month, and year
[email protected] Time format with the hour, minute, and AM or PM
Ctrl+Shift+! Two decimal places, thousands separator, and a hyphen for negative values

See also this tip in French: Comment changer le format de numéro facilement.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.