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+~


How do I format data quickly in Excel?,How do I quickly convert numbers in Excel?,What is the shortcut for Number Format in Excel?,How do you quickly change numbers to thousands in Excel?,
Format numbers as currency,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Category

📚
Learning
Transcript
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.

Recommended