How to change number format easily

Excel 2016 2013 2010 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

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