In this article:

Google Sheets Custom Number Format for Millions (2024 Guide)

May 8, 2024

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.

google sheets number format millions

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.

google sheets custom number format millions

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.

custom number format google sheets millions

Here is an example of what it should look like:

custom number format for millions in google sheets

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 article on how to use the CEILING function in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->