How to abbreviate numbers in Excel?
If you have a list of large numbers typed in Excel and now you want to abbreviate them as below screenshots shown, you can read this tutorial for the details.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
You can customize the number formatting in the Format Cells dialog.
1. Select the numbers you need to abbreviate, and right click to select Format Cells from the context menu.
2. In the Format Cells dialog, click Number > Custom, and type [>999999]#,,"M";#,"K" into Type textbox. See screenshot:
3. Click OK to close dialog, now the large numbers are abbreviated.
Tip: If you just need to abbreviate the large number as thousand “K” or million “M”, you can type #,"K" or #,,"M" into the textbox. And if you want to display much larger number like 12000000000 or 12000000000 as 12B or 12T, you need to type #,,,"B" or #,,,,"T". And if you need to show million and trillion together, you need this [>999999999.999]#,,,"B";[>999999.999]#,,"M";#,##0 _M.