Excel - Abbreviate huge numbers

Are you often working with very large numbers, possibly hundreds of thousands or even millions? Those numbers can become very long and difficult to read. There's an easy way to format them in Excel so they appear abbreviated. For example, 100,000 would appear as 100K. Here's what to do:

In the above example we have a couple of huge numbers. Select both cells, right click and click Format Cells.

Click Custom

Enter:
[>999999]#,,"M";#,"K"

Click OK

Now the numbers will appear abbreviated:

If you use pivot tables, this is invaluable. You can format the measures (Values) to be abbreviated just as above. Click the down arrow on the measure in the Values box, click Value Field Settings, click Number. This brings up the Format Cells window. Add the Custom template as explained above. Whenever you use that particular measure all the numbers will be formatted with this abbreviated format.