How to Format Numbers in Thousands and Millions in Excel?

• Last Updated : 22 Mar, 2022

Now, when we give these extremely large raw numbers to any individual, it would be really hard for that person to digest these numbers in one glance. To make it more convenient, we can write these numbers in a particular way like writing the numbers in thousands or millions. If we express Martin’s net worth as 456 K, Miranda’s net worth as 335 K then it becomes much more intuitive and readable to the user.

In this article, we are going to read about how can we format these numbers as thousands and millions in Excel. In this tutorial, we will be formatting the net worth in thousands and company revenue in millions. Microsoft Excel gives its users the power to apply custom formatting using the format cells tool.

Formatting net worth in thousands using the format cells dialog box

Step 1: Select the desired cells that we want to apply the formatting on.

Step 2: Press Ctrl+1 ( command+1 if using macOS) on the keyboard to open the format cells dialog box.

Step 3: Under the Number tab from the left-hand side, in the Category options, select the Custom option.

Step 4: In the Type option, enter #,##0, K, in the Sample, we can preview that the number 456235 will be displayed as 456 K.

Step 5: Now press the OK button to apply the formatting to all the selected cells. The final output will be displayed as shown in the below-given image.

Note: When we click on any of the formatted cells and observe the content in the formula bar original number will be displayed which verifies that only the formatting has been changed and the number has been stored as it is in the backend.

Formatting the company revenue in millions using the format cells dialog box

Step 1: Select the desired cells that we want to apply the formatting on.

Step 2: Press Ctrl+1(command+1 if using macOS) on the keyboard to open the format cells dialog box.

Step 3: Under the Number tab from the left-hand side, in the Category options, select the Custom option.

Step 4: In the Type option, enter #,##0,, “M”, in the Sample, we can preview that the number 253678654 will be displayed as 254 M.

Step 5: Now press the OK button to apply the formatting to all the selected cells. The final output will be displayed as shown in the below-given image.

Note: As seen in the previous case, when we click on any of the formatted cells and observe the content in the formula bar original number will be displayed which verifies that only the formatting has been changed and the number has been stored as it is in the backend.

My Personal Notes arrow_drop_up
Recommended Articles
Page :