Number Format – Millions in Excel & Google Sheets
This tutorial demonstrates how to format numbers as millions in Excel and Google Sheets.
Format Numbers as Millions
If you want to present large numbers in Excel visually more appealing, you can format them as millions. Say that you have the following set of numbers in column B.
In order to format the list of numbers as millions, follow the next steps.
1. (1) Select a range of numbers (B2:B7), and in the Ribbon, (2) go to the Home tab and (3) click the Number Format icon in the right bottom corner of the Number group.
2. In the Format Cells window, (1) go to the Custom category, and (2) enter “#,, “Million”” in the Type box, and (3) click OK.
As a result, all numbers in the range, are formatted as millions. In this format, every comma replaces three digits.
Note: If you want to include thousands as a single decimal in the millions formatting, just enter “#0.0,, “Million”“.
Sometimes, you can use only M to indicate millions. This can be useful when creating scorecards to present KPI metrics. In that case, just enter “#0.0,,”M”“.
See also: Find out how to format numbers as thousands.
Format Numbers as Millions in Google Sheets
Similar to Excel, you can also format numbers as millions in Google Sheets. To achieve this, follow the next steps.
1. (1) Select a range of numbers B (B2:B7), and in the menu, (2) go to the Format > Number > Custom number format.
2. In the Number format box, enter “0,, \Million”
As a result, the numbers are formatted as millions.
Similar to this, you can enter “0.0,, \Million” to include thousands as a single decimal.
To format with M, enter “0.0,,\M“.