Windows Keyboard Shortcut of the Day

In Excel, type a number into a cell (such as “54.1″) and press Enter. Then press Ctrl+Shift+4 (or another way to think of that is Ctrl+$). Instantly the currency format is applied to the selected cells, and your “54.1″ becomes “$54.10″.

You have quite a few other options as well:

• Ctrl+~ (Ctrl+Shift+`): General format
• Ctrl+! (Ctrl+Shift+1): Number format (with two decimal places and the thousands separator)
• Ctrl+@ (Ctrl+Shift+2): Time format
• Ctrl+# (Ctrl+Shift+3): Date format
• Ctrl+$ (Ctrl+Shift+4): Currency format
• Ctrl+% (Ctrl+Shift+5): Percentage format
• Ctrl+^ (Ctrl+Shift+6): Exponential format