How do you format millions to thousands in Excel?

How do you format millions to thousands in Excel?

If you want to format large numbers into thousands or millions, here are the steps:

  1. Highlight the cells to be formatted.
  2. Go to the format dialog box ( Ctrl + 1)
  3. Under Category select Custom.
  4. In the Type box, for Thousands enter #,###, “K” for Millions enter #,###,, “M”
  5. Click OK.

How do I show numbers in millions in Excel?

Excel: Display an Axis in Millions Strategy: Double-click the numbers in the axis labels. In the resulting settings area, find the Display Units dropdown and choose Millions. Change the axis Display Units. Results: Excel removes the zeros and adds a label indicating that the numbers are in millions.

How do I change 1K to 1000 in Excel?


  1. Select the cells you want format.
  2. Press Ctrl+1 or right click and choose Format Cells… to open the Format Cells dialog.
  3. Go to theNumber tab (it is the default tab if you haven’t opened before).
  4. Select Custom in the Category list.
  5. Type in #,##0.0, “K” to display 1,500,800 as 1,500.8 K.
  6. Click OK to apply formatting.

How many zeros are there in a million?

6 Zeros
1 Lakh = 100 Thousands = 1 followed by 5 Zeros = 100,000. 10 Lakhs = 1 Million = 1 followed by 6 Zeros = 1,000,000.

What is the number 1K?

Verify Number Formats: English

Numeric Format Compact-Short Compact-Long
1,000 1K 1 thousand
1,100 1.1K 1.1 thousand
1,500 1.5K 1.5 thousand
2,000 2K 2 thousand

How do I change 1k to 1000 in Excel?

How do you display numbers in millions in Excel?

Large numbers in Excel can be formatted so they can be shown in “Thousands” or “Millions”. By using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions.

How do you format a number in Excel?

How to create a custom number format in Excel Select the cell to be formatted and press Ctrl+1 to open the Format Cells dialog. An alternative way to do is by right-clicking the cell and then going to Format Cells > Number Tab. Under Category, select Custom. Type in the format code into the Type Click OK to save your changes.

How to stop Excel AutoFormat?

Stop auto formatting number by adding a space or apostrophe.

  • Stop auto formatting number by format as Text.
  • number string to standard date.
  • charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails
  • What is formatting in Excel?


  • 3.
  • 4.
  • FG.
  • FK.
  • FN
  • FA.