Show Numbers in Thousands or Millions in Excel (really easy way)

In this video, I will show you a really easy way to show numbers in thousands in Excel (or in millions or billions).

You can do this using the custom number formatting where you can specify the format to show values in thousands (or millions) and also add the word "Thousand" or "K" to it.

The best part about this method is that it only changes how your data looks in Excel and has no impact on the value within the cell. So you can still use the cell in calculations.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[henrychijiokennanna]

You are a lifesaver. so long I have been looking for ways to convert my performance table to per unit value, we normally work in per million unit, and this video has given me that solution. Thanks a lot

[melindamichale]

Thank you for being to the point and easy to follow! Exactly what I was looking for

[nishaspatel]

That's what I've been looking for, so impressed with all your videos, they're so easy to understand. Thank you so much.
sometimes it's so hard to put in the youtube search bar that what your question is but with your videos - it's just putting one word and get your answer.

[LUCKYMASON]

This is what I am looking for! Thank you veyr much for showing how to convert numbers to thousand format. Also, in the above video, it show 45581.86K; what should I do to show it as 45, 581.86K? Is this possible?

[danielhartjes]

Very nice job. You can also add a $ in the first position for formatting purposes if you're using dollars.

[kellychung]

What about changing numbers to Thousands (K) or Millions (M)? For example, from 6, 000 to 6K

[flickhunter]

Just wow. the easiest explanation. thanx man

[ravibala]

Thank you so much for the video, was so helpful in getting the formatting of my numbers in millions.

[barbaraengle]

You are brilliant! I am using immediately. Thank you!

[LauraMFoleyDesign]

Thank you so much! This was the easiest way to achieve the result I wanted that I could find.

[javedakhtar-rikv]

Thank you very much for nice tip. Can we remove letter M after converting a figure into million????

[melodywhispered]

Hi Sumit, Thank you for the great tips including this one. Can you tell me how can I use this tip for showing values in crore? Thanks

[jasondude]

Thank you! you did what others could not do

[ganeshkrishna]

Extremely useful. Very well explained sir.

[statsinside]

please tell me how can i convert 170.8 million into a normal number.

[MrVave]

Thank you very much!!! It helped me a lot! Keep the good work going! God bless you.

[rinkuthakur]

It's a useful for a chart axis . THANKS SIR.

[yogirajoo]

Many thanks Sumit ! On the same lines how can I format numbers in Indian convention like Lakh and Crore?

[afolabiblessing]

How can i change it from showing Millions (M) or Thousand (k), to showing full digit

[sedarathnadcd]

super work, easy to understand, Thank you