00:00This is how you quickly format data in Excel using these special hotkeys.
00:03To format number as currency, simply press Ctrl-Shift-Dollar to format a number as a number with comma,
00:10and in two decimal places, press Ctrl-Shift-Exclamation.
00:15Hotkey for formatting a number as percentage is Ctrl-Shift-Percent.
00:19Hotkey for formatting number as scientific number is Ctrl-Shift-Caret.
00:24Press Ctrl-Shift-Pound or hash to format number as date, and to format number as time, simply press Ctrl
00:31-Shift-Add.
00:33Last but not least, to format a number as general, press Ctrl-Shift-Tilde.