How to Abbreviate Numbers in Excel: 3 Easy Methods

Method 1 – Apply a Predefined Format to Abbreviate Numbers


  • Select column D to format it.

Use Predefined Format to Abbreviate Numbers

  • Right-click on the selected range.
  • A context menu bar pops up.
  • Tap the Format Cells option.

  • The Format Cells options menu opens up.
  • Select Number, then Custom options.
  • In the Type box, scroll down to tap [>999999]#,,”M”;#,”K”. You can also copy & paste it.
  • Hit OK.

  • The abbreviated number format appears.

Method 2 – Compress Numbers Using a Custom Format for Cells in Excel


  • Select the desired range you want to format.
  • Right-click on it and then select the Format Cells option.

Compress Numbers Using Custom Format Cells in Excel

  • The Format Cells menu will open.
  • Go to Number > Custom > Type.
  • In the Type box, insert the format 0,K.
  • Press OK.

  • Here’s the result.

Method 3 – Insert the ROUND Function to Abbreviate Numbers


  • Insert the following formula in cell D5:
=ROUND(C5/1000000,1)& "M"

Insert ROUND Function to Abbreviate Numbers

  • Press Enter and use the autofill feature to fill the other cells.

How Does the Formula Work?

  • C5/1000000

This part of the formula divides the number in cell C by 1000000.

  • ROUND(C5/1000000,1)

The ROUND function syntax returns 2 arguments. C5/1000000 represents the number syntax that rounds the number. 1 indicates num_digits syntax which returns the number of digits to round in.

  • ROUND(C5/1000000,1)& “M”

The & “M” adds the text M.

Download the Practice Workbook

<< Go Back to Excel Abbreviation | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Yousuf Khan
Yousuf Khan

Yousuf Khan has been working with the ExcelDemy project for over one year. He has written 47+ articles for the ExcelDemy site. He also solved a lot of user problems with ExcelDemy Forum. He has interests in Excel & VBA, Desktop and mobile applications, and projects & templates. He completed his graduation and post-graduation in Information Technology from Jahangirnagar University. Currently, he works as a VBA & Excel Content Developer in ExcelDemy projects, writing unique and informative content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF