Displaying Large Numbers in K (thousands) or M (millions) in Excel
If you want to show the numbers in Millions, simply change the format from General to 0,,"M". The figures will now be 23M. So essentially we are adding 2 commas instead of a single comma this time. If you would like to see the decimal point for the millions figure, like 23.6M, you can format it to 0.0,,"M"
信息服务