The trick is to put 1 comma and 2 comma at the end of the format setting 0 for thousand and million respectively. The custom format to show number in thousand or in million is simple.

50 Things You Can Do With Excel Pivot Tables Microsoft Excel

0 k 0 m the k or m is optional depend on whether you want to show it in the header or in the figure itself.

Excel format in thousands. This allows you to present cleaner numbers and avoid inundating your audience with overlarge numbers. Format numbers to millions thousands in excel step 1. 1 highlight the cells to be formatted 2 go to the format dialog box ctrl 1 3 under category select custom.

Large numbers in excel can be formatted so they can be shown in thousands or millions. Ways of displaying thousands and millions. Press ctrl 1 or right click and choose format cells to open the format cells dialog.

Open the format cell dialogue by pressing ctrl 1 or right click on the cell and select format cells. And 0. Here s an example of a custom excel format code.

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. Type in 0 0 k to display 1 500 800 as 1 500 8 k. Right click on the numbers you want to format and select format cells.

Go to the number tab it is the default tab if you haven t opened before. If you want to format large numbers into thousands or millions here are the steps. In microsoft excel you can improve the readability of your dashboards and reports by formatting your revenue numbers to appear in thousands.

Section we need to apply the formatting code. Format for positive numbers display 2 decimal places and a thousands separator. Select the cells you want format.

Select the cells which you want to display in thousands. Format for negative numbers the same as for positive numbers but enclosed in parenthesis. 0 0 and confirm with ok.

Now go to custom option. Then click ok button and all the numbers have been formatted as. Select the cells contain the numbers you want to format and then right click format cells option from.

Select custom in the category list. In the format cells dialog box under the number tab select custom from the left pane in the type text box. Format for zeros display dashes instead of zeros.

On the number tab click on. To show your numbers in thousands highlight them right click and select format cells. Below is the formatting code to change the formatting of the numbers.