How to Display Numbers in Thousand(K), Million (M) or Billion(B) Format in Excel

In this tutorial you will learn how to display the numbers in thousand, million or billion format in Microsoft Excel. We will use K for thousand, M for million and B for billion.

For example, in a column you have some numbers in the general format, you need to display these numbers in KMB format.

Follow these steps to display the numbers in thousand, million or billion format.

1. Prepare the numbers to change the formatting.
2. Select the numbers range.
3. Right click on the mouse.
4. Click on “Format Cells”.
5. Click on “Number” tab. Generally it is auto selected.
6. Click on “Custom” option.
7. In the type, remove “General” and write below given custom formatting code.
8. Click on “Ok”.

[<1000000]0.00," K";[<1000000000]0.00,," M";0.00,,," B"

Instead of displaying KMB, if you want Thousand, Million or Billion, the format code would be;

[<1000000]0.00," Thousand";[<1000000000]0.00,," Million";0.00,,," Billion"

If you want to display different digits after decimal, change the “0.00” part of the code. If you want to keep 4 digits after decimal, use “0.0000” instead of “0.00”.

[<1000000]0.0000," K";[<1000000000]0.0000,," M";0.0000,,," B"

What IF You Want Normal Formatting

If you want to remove the KMB format and use the normal one, follow these steps.

1. Select the range of numbers.
2. Right click on mouse.
3. Click on “Format Cells”
4. Click on “General” or “Number”.
5. Click on Ok.

This is all about changing the numbers to thousand(K), million(M) or billion(B) format in Excel.

If this article helped you, please share this to Excel learners. If you have any comments or queries, kindly leave your comments. Thank You.