How to Round Numbers to Millions in Excel (With Examples)

You can use the following formulas to round numbers to millions in Excel:

Formula 1: Round Number to Nearest Million

=ROUND(B2,-6)

This particular formula rounds the number in cell B2 to the nearest million.

For example, if cell B2 contained 1,453,000 then this formula would return 1,000,000.

Formula 2: Round Number to Nearest Million with One Decimal Place

=ROUND((B2/1000000),1)&"M"

This particular formula rounds the number in cell B2 to the nearest million with one decimal place.

For example, if cell B2 contained 1,453,000 then this formula would return 1.5M.

Formula 3: Round Number to Nearest Million with One Decimal Place and Dollar Sign

="$"&ROUND((B2/1000000),1)&"M"

This particular formula rounds the number in cell B2 to the nearest million with one decimal place.

For example, if cell B2 contained 1,453,000 then this formula would return $1.5M.

The following example shows how to use each of these formulas in practice.

Example: Round Numbers to Millions in Excel

Suppose we have the following dataset in Excel that shows the annual salary of various athletes:

We can type the following formulas into cells C2, D2 and E2 to round the values in column B to the nearest million using different formats:

We can then click and drag these formulas down to each remaining cell in each column:

Excel round number to millions

Columns C, D and E now display the numbers in column B rounded to the nearest million in various formats.

Note that you can also round to a different number of decimal places by changing the value of the last argument in the ROUND function.

For example, you could use the following formula to round each number to the nearest million with two decimal places instead:

=ROUND((B2/1000000),2)&"M"

For example, if cell B2 contained 1,453,000 then this formula would return 1.45M.

The following tutorials explain how to perform other common tasks in Excel: