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.
Step 1
Select the cell and right click to select the Format Cell option.
Step 2
#,##0,”K”; (#,##0,”K”)
Go to custom and insert the above format as shown below.
And press OK.
Step 3
How to show the number in M format in excel.
Use the format #,##0.00,, “M”
And press OK.
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.