How do you custom format numbers in millions in Excel?

Steps

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

How do I create a custom date format in Excel 2007?

Create a custom date format

Select the cells you want to format.
Press CTRL+1.
In the Format Cells box, click the Number tab.
In the Category list, click Date, and then choose a date format you want in Type.
Go back to the Category list, and choose Custom.

How do you custom format a billion in Excel?

In the Format Cells dialog box, under the Number tab, select Custom from the left pane, in the Type text box, enter the below format code as you need: Format numbers in thousand: 0, “K” Format numbers in millions: 0,,”M” Format numbers in billions: 0,,,”B”

How do you make millions in Excel?

Click the ribbon Home, right-click on the cell, then expand the default to show “Format Cells” dialog. In the Format Cells dialog box, on the Number tab, select Custom, then enter #,, “Million” where it says General.

How do I change the decimal places in Excel 2007?

In this article

Introduction.
1Click the Office Button and then click the Excel Options button.
2Click the Advanced tab.
3Select the Automatically Insert a Decimal Point check box in the Editing Options section.
4(Optional) Type a new number in the Places text box or use the spinner buttons to change the value.

How do you display millions?