Show Numbers as Thousands (K) or Millions (M) in Excel

This video demonstrates how to format large values so that they are easier to read. In particular, the video looks how to format thousands so they appear as £66.8 K and millions so they appear as £1.52 M. The video will also show you how to define how many decimal places you want to display.
------------------------

[kellychung]

THANK YOU SO MUCH! Other videos in a similar topic were confusing and not straight to the point. Not only that, their codes were too long while yours was brief and easy! I just recommended my accounting classmate this video!

[NateHamiltonN]

This was the best bang-for-the-buck I've gotten from your videos! Fabulous content! Keep it coming!!!

[AmbutuMalone]

Thank you so much! I needed to format a chart and could not figure out how to show the "K" values in the chart.

[MichaelSalguero]

Very helpful. First result on a Google Search and it worked exactly as needed.

[elsachoi]

Hi Chester, if original number is 90, 500, 000, 000 and I want to convert to 90, 500 (unit is million), with a 'common' between 90, 500, instead of showing 90500 what shall I do?

[JuergenTolksdorf]

Any idea how this is supposed to work on a Mac?