How to change number format easily

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

Ask a Question

We use your email only for the communication between you and our team.

Your email Please enter your email Your email

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

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.