Quickly format data in Excel - Excel Tips and Tricks
Learn how to quickly format data in Excel.
Here are the hotkeys featured in my video.
Hotkey for format numbers as currency
Ctrl+Shift+$
Hotkey for format numbers as a number with comma and 2 decimal place
Ctrl+Shift+!
Hotkey for format numbers as percentage
Ctrl+Shift+%
Hotkey for format numbers as scientific numbers
Ctrl+Shift+^
Hotkey for format numbers as date
Ctrl+Shift+#
Hotkey for format numbers as time
Ctrl+Shift+@
Hotkey for format numbers as general
Ctrl+Shift+~
#tips #excel #shorts #fyp
