Display Number In K Or M Format In Excel

To show thousands as K and millions as M in a report is a good practise specially we show large amount of money metrics.

Suppose we want to the below number in K or M format like 1,000K or 1M.

Capture

Step 1

Select the cell and right click to select the Format Cell option.

Capture




Step 2

#,##0,”K”; (#,##0,”K”)

Go to custom and insert the above format as shown below.

Capture

And press OK.

Step 3

How to show the number in M format in excel.

Use the format  #,##0.00,, “M”

Capture

And press OK.




Capture

You could adjust the decimal places by adjusting the decimal places in the format that we have pasted in the custom box.

Hope this helped.

 

Share The Knowledge

Random Posts

Leave a Reply