Skip to playerSkip to main content
  • 11 months ago
Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.

In this video lesson, we will learn about Formatting Numbers in Microsoft Excel

You can access the entire Microsoft Excel Course in the following playlist:
https://thao.funnymoment.net/playlist/xa9hyw

Category

📚
Learning
Transcript
00:00so in Microsoft Excel you can go ahead and display out numbers in different ways for example I'm
00:10going to go around and add in some number right here just like this random numbers and you can
00:15see that the display for it is quite straightforward but let's say I want to go ahead how that actually
00:20displays so for that I'm going to go around over here onto general and let's select number once
00:26you do that you can see that decimal points are added in and you can go ahead and decrease or
00:31increase up the decimal points right here just like this as well apart from that you can also go
00:36ahead and then expand this and here you can see the number format right here which allows you to go
00:41ahead and add in commas does display that as percentage or even currency values right here
00:48but let's focus on the number itself so to do that I'm going to go around over here the drop down
00:53menu and click on more number format so here you can see that number option is here so you can go
00:58ahead and choose decimal places and choose the number format from over here we can display it out
01:03as negative number use the uh thousand separator right here you can even go ahead and choose these
01:10out as you can see so let's choose this one inside bracket press ok right here and this is where you
01:16have so let me just go around over here onto more number formats you can go ahead and choose this
01:21number format as you want or you can go ahead and choose the negative number format that you have
01:26as well so if I were to go around add a negative number format that is what you have as you can see
01:31right here and so forth right here so you can go ahead and choose the number format as you wish and
01:36just like that the color and display settings for the number formatting changes out so that is how you
01:42can go ahead and format out numbers inside of microsoft excel so if you found this video useful be sure to hit the
01:50like button don't forget to share this out with your friends and family and for more contents like
01:56these do follow simple tutorials

Recommended