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