Tips & Tricks

Excel Tip - Shortcuts for Formatting Numbers

Here are a few useful shortcut keys that can be used when formatting numbers in Microsoft Excel:

  • Select the cell(s) containing the numbers you wish to format.
  • To apply the Currency style, press CTRL SHIFT and $ on the keyboard
  • To apply the Comma style, press CTRL SHIFT and ! on the keyboard
  • To apply the Percentage style, press CTRL SHIFT and % on the keyboard
  • To apply the General style, press CTRL SHIFT and # on the keyboard