See all How-To Articles

Number Format – Millions in Excel & Google Sheets

This tutorial demonstrates how to format numbers as millions in Excel and Google Sheets.

 

millions number format initial data

 

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.

 

millions number format initial data

 

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.

 

millions number format 1

 

2. In the Format Cells window, (1) go to the Custom category, and (2) enter “#,, “Million”” in the Type box, and (3) click OK.

 

millions number format 2

 

As a result, all numbers in the range, are formatted as millions. In this format, every comma replaces three digits.

 

millions number format 3

 

Note: If you want to include thousands as a single decimal in the millions formatting, just enter “#0.0,, “Million”“.

 

millions number format 4

 

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”“.

 

millions number format 5

 

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.

 

google sheets millions number format 1

 

2. In the Number format box, enter “0,, \Million

 

google sheets millions number format 2

 

As a result, the numbers are formatted as millions.

 

google sheets millions number format 3

 

Similar to this, you can enter “0.0,, \Million” to include thousands as a single decimal.

 

google sheets millions number format 4

 

To format with M, enter “0.0,,\M“.

 

google sheets millions number format 5