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 more visually appealing way, you can format them as millions. Say you have the following set of numbers.

 

millions number format initial data

 

To format the list of numbers as millions, follow these steps:

  1. Select the range of numbers (B2:B7) you want to format, and in the Ribbon, go to the Home tab and click the Number Format icon in the bottom-right corner of the Number group.

 

millions number format 1

 

  1. In the Format Cells window, go to the Custom category, and enter “#,, “Million”” in the Type box, and 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 these steps:

  1. Select the range of numbers (B2:B7) you want to format, and in the Menu, go to the Format > Number > Custom number format.

 

google sheets millions number format 1

 

  1. In the Custom number formats 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