How to Abbreviate Currency Values as K, M, and B in Excel？

Large currency values can make financial reports, dashboards, and sales worksheets difficult to scan. Instead of displaying amounts such as $125,000, $2,500,000, or $3,600,000,000, you can shorten them to:

The letters represent commonly used number units:

• K = thousand
• M = million
• B = billion

For example, $24.5K represents $24,500, while $3.2M represents $3,200,000.

In Excel, you can use a custom number format to change only how the values appear, a formula to generate abbreviated results in another column, or Kutools for Excel to format an entire range without memorizing format codes.

Abbreviate Currency Values with a Custom Number Format

Automatically Display Currency Values as K, M, or B

• Method 1: By Custom number format
• Method 2: By Formula
• Method 3: By Kutools for Excel

Which Method Should You Use?

Frequently Asked Questions

Conclusion

Abbreviate Currency Values with a Custom Number Format

When all values in a range use the same unit, you can apply a simple custom number format to display them in thousands, millions, or billions.

This method changes only how the values appear. It does not divide, round, or replace the original numbers stored in the cells.

1. Select the currency values you want to abbreviate.
2. Press Ctrl + 1 to open the Format Cells dialog box.
3. Select Custom from the Category list. And then enter the following code in the Type box:

   ✓ Format numbers in thousand: $0.0,"K"

   ✓ Format numbers in millions: $0.0,,"M"

   ✓ Format numbers in billions: $0.0,,,"B"

   

4. Click OK.

Result: The values are now displayed in currency format and abbreviated as thousands, millions, or billions.

Display Currency Values in Thousands (K)--- $0.0,"K"

Display Currency Values in Millions (M)--- $0.0,,"M"

Display Currency Values in Billions (B)--- $0.0,,,"B"

Custom Currency Format Summary

Changing the number of placeholders controls the displayed precision:

• 0 displays no decimal places.
• 0.0 displays one decimal place.
• 0.00 displays two decimal places.
• 0.# displays up to one decimal place without forcing a trailing zero.

For example:

This displays 12,000,000 as $12M and 12,500,000 as $12.5M.

Use a Different Currency Symbol

When creating custom number formats in Excel, you are not limited to the dollar sign ($). You can easily use a different currency symbol depending on your region or reporting requirements.

To change the currency symbol, simply replace $ in the format code with the desired symbol. For example:

• Euros (€): €0.0,"K"
• British Pounds (£): £0.0,,"M"
• Japanese Yen (¥): ¥0,,,"B"

This allows the same K, M, and B abbreviation logic to work across different currencies while keeping your financial reports consistent and localized.

Automatically Display Currency Values as K, M, or B

A fixed number format works well when all values have a similar size. However, a dataset may contain thousands, millions, and billions in the same column. In this situation, you need a method that checks each value and applies the appropriate abbreviation automatically.

Method 1: Automatically Display K, M, or B with a Custom Number Format

A conditional custom number format can switch between thousands, millions, and billions according to the size of each value.

1. 1. Select the currency values you want to abbreviate.
   2. Press Ctrl + 1 to open the Format Cells dialog box.
   3. Select Custom from the Category list. And then enter the following code in the Type box:
      [>=1000000000]$0.0,,,"B";[>=1000000]$0.0,,"M";$0.0,"K"

      Tips: The format contains three sections:

      [>=1000000000]$0.0,,,"B"

      Values of at least one billion are divided by one billion for display and followed by B.

      [>=1000000]$0.0,,"M"

      Values of at least one million are divided by one million for display and followed by M.

      $0.0,"K"

      All remaining values are divided by one thousand for display and followed by K.

   

4. Click OK.

Result: The currency values are now automatically displayed as K, M, or B based on the values, while the original values remain unchanged.

Advantages

• Keeps the original numeric values unchanged
• Works with calculations, PivotTables, and charts
• Requires no helper column
• Can be applied to an entire range at once
• Updates automatically when cell values change

Limitations

• Excel custom formats allow only two explicit conditions
• Values below 1,000 are displayed as fractions of K
• The format controls appearance only
• The displayed abbreviation cannot be extracted as text without another formula

Method 2: Automatically Add K, M, or B with a Formula

A formula is useful when you want the abbreviated result in a separate column or need more control over values below 1,000.

1. 1. Select a blank cell and copy and paste the following formula:

      =IF(ABS(A2)>=1000000000,TEXT(A2/1000000000,"$0.0")&"B",
       IF(ABS(A2)>=1000000,TEXT(A2/1000000,"$0.0")&"M",
       IF(ABS(A2)>=1000,TEXT(A2/1000,"$0.0")&"K",
      TEXT(A2,"$0.00"))))

   2. Press Enter, and then fill the formula down to apply the formula to the remaining rows.

How the Formula Works

The formula checks the absolute value of A2 from the largest unit to the smallest.

Advantages

• Handles values below 1,000 separately
• Produces results in another column
• Allows customized symbols, units, and decimal places
• Can be adapted to more complex business rules

Limitations

• The result returned by TEXT is text rather than a numeric value
• The abbreviated results cannot be summed directly
• A helper column is required
• The formula is longer and more difficult to maintain

Method 3: Automatically Abbreviate Currency Values with Kutools for Excel

If you do not want to create custom format codes or maintain a nested formula, Kutools for Excel provides a quicker way to format large numbers.

Kutools for Excel’s Number Format Helper provides ready-made currency formats, so you can shorten large values without entering custom format codes or formulas. With the K/B/M Compact Currency format, values below one million remain in standard currency format, while larger values are automatically displayed in millions or billions.

1. Select the values you want to format.
2. Go to Kutools tab, and click Format > Number Format Helper, see screenshot:
   

3. In the Number Number Format Assistant dialog box:
   • In Category pane, select Currency.
   • Choose K/M/B Compact Currency from the Format list. Check the converted results in the Preview pane.
     

4. Click OK.

Result: The selected values are now displayed in a more compact currency format.

Which Method Should You Use?

Frequently Asked Questions

Conclusion

Abbreviating large currency values as K, M, and B can make Excel worksheets, dashboards, charts, and financial reports much easier to read.

By choosing the appropriate method, you can present large currency values clearly without changing the underlying financial data.