Google Sheets Custom Number Format for Millions (2024 Guide)

How to Set Up a Custom Number Format in Google Sheets for Millions 

To set up a custom number format in Google Sheets that displays numbers in millions, you can follow these steps:

Step 1: Select Your Cells

Click on the cell or range of cells that you want to format. You can click and drag to select multiple cells, or click on the column and row headers to select an entire column or row.

Step 2: Open the Format Menu

With your cells selected, go to the menu at the top of the screen and click on “Format.” This will open a dropdown menu.

Step 3: Go to Custom Number Format

In the dropdown menu, hover over “Number” to open another side menu where you will see various pre-set number formats. At the bottom of this menu, click on “Custom number format” to open the custom format dialogue box.

Step 4: Enter Custom Format for Millions

In the custom format dialogue box, you will enter the custom format code to display numbers in millions. Use the following format:

#,##0.00,,"M"

This format works as follows:

• #,##0.00 ensures that your number will have a comma as a thousand separator, and it will display two decimal places.
• The two commas after 0.00 tell Google Sheets to divide the number by 1,000,000 (each comma is a division by 1,000).
• "M" adds the letter M immediately after the number to signify millions.

Step 5: Apply the Custom Format

After typing in the custom format, click “Apply” to apply it to the selected cells.

Here is an example of what it should look like:

We hope that this article has helped you and given you a better understanding of how to set up a Google Sheets custom number format for millions. If you enjoyed this article, you might also like our articles on how to troubleshoot when Google Sheets is running slow and how to use the CEILING function in Google Sheets.