Yes. In Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Number > Custom, and enter 0"m" to append m without changing the value; use #,##0.0,,"m" to display values in millions. The first format adds a suffix only, while the two trailing commas in the second format scale the displayed number.
What Adding M to a Number Format Means
A number format changes how a value looks in a cell, not the value Excel stores. For example, if A1 contains 1250 and you apply 0"m", the cell displays 1250m. The underlying value remains 1250, so a sum or other calculation still uses 1250. This is useful when m is a label or unit, but it does not mean “millions.”
To abbreviate a value of 1,250,000 as 1.3m, use a format that both scales the display and adds a suffix. In #,##0.0,,"m", the two commas after the decimal-place placeholder scale the displayed number down by 1,000 twice. The format therefore shows millions and rounds the result to one decimal place. The stored value stays 1,250,000.
That distinction matters when a worksheet is shared. A reader may interpret 1250m as 1,250 million, even if the cell actually contains 1,250. Choose a format that matches the actual size and meaning of the values, and label the column clearly when there could be ambiguity.
How to Add an M Suffix in Excel
For a suffix that does not scale values, apply a custom format in desktop Excel for Windows:
- Select the cells or range you want to format.
- Press Ctrl+1 to open the Format Cells dialog.
- On the Number tab, select Custom in the Category list.
- Click the Type box, enter
0"m", and select OK.
The zero is a digit placeholder: Excel displays a digit in that position, including a zero when the value is zero. The quotation marks make m a literal character rather than a format instruction. With values 8, 1250, and 0, the cells display 8m, 1250m, and 0m.
To include thousands separators, use #,##0"m". A value of 1250 then displays as 1,250m. To show one decimal place without scaling, use #,##0.0"m"; the same value displays as 1,250.0m. These formats are useful for quantities whose unit is m, but they do not convert the quantities to millions.
Choose Between a Suffix and Million Scaling
Decide what m is intended to communicate before choosing a format. It might be a unit label, a short display suffix for million-sized values, or part of a value such as a code. The appropriate custom format depends on that meaning:
0"m"appends m. A value of 1250 displays as 1250m.#,##0"m"appends m and uses digit grouping. A value of 1250 displays as 1,250m.0.0,,"m"scales by one million and displays one decimal place. A value of 1,250,000 displays as 1.3m.#,##0.0,,"m"also scales by one million and includes grouping when the displayed number is large enough to need it.#,##0,"k"scales by one thousand and uses k, so 1250 displays as 1k when formatted with zero decimal places.
The last example rounds 1.25k to 1k because it has no decimal-place placeholder. If that loss of visible precision is not appropriate, use #,##0.0,"k", which displays 1250 as 1.3k. Think about the precision readers need, not just how compact the result looks.
How the Custom Format Code Works
Excel custom number formats use placeholders and formatting characters. In #,##0.0,,"m", the number-sign and zero placeholders control which digits appear, the comma between them requests digit grouping, and the decimal point and zero after it request one decimal place. The two commas after the decimal-place placeholder scale the displayed value by a million. The quoted m is printed as text.
In general, each scaling comma at the end of a number format divides the displayed value by 1,000. One trailing scaling comma is used for thousands; two are used for millions. This is a display rule, not a calculation: Excel does not replace the original value with a divided result. You can still reference the cell in a formula and get its full stored number.
Quotation marks are important for literal text. In date and time formats, m can represent a month or, in the right context, minutes. A custom number format containing a quoted m explicitly requests the letter m. If you add other literal text, put it in quotation marks too, for example 0" million" to display 2 as 2 million. That example adds words but does not scale the value.
Control Decimal Places, Negatives, and Zero
Choose decimal places to balance readability and precision. For a million-scaled display, 0,,"m" rounds to a whole million, while 0.0,,"m" shows one decimal place and 0.00,,"m" shows two. Thus 1,250,000 appears as 1m, 1.3m, or 1.25m, respectively. The original number is unchanged in every case.
Rounding can hide meaningful differences. If two values are 1,240,000 and 1,260,000, a whole-million format can make them appear identical even though they differ by 20,000. Add decimal places, keep the full values visible in another column, or provide a note about the display precision if readers need to compare close figures.
A custom number format can also define separate appearances for positive numbers, negative numbers, and zero. For example, #,##0.0,,"m";[Red](#,##0.0,,"m");- shows positives with an m suffix, negatives in red parentheses, and zero as a dash. Sections are separated by semicolons in the order positive;negative;zero. Use this only if those display conventions suit the worksheet; the cell still contains its numeric value.
Common Problems and Misunderstandings
- The number did not become smaller. A suffix-only format such as
0"m"adds a character but performs no scaling. For millions, use two trailing scaling commas before the quoted suffix. - The display is rounded unexpectedly. A format with no decimal placeholder rounds the displayed result to a whole number. Add
.0or.00to show more precision. - The letter does not appear as intended. Quote literal letters in custom number formats. This is especially helpful with m because it also has a meaning in date and time formats.
- The cells show the format code instead of applying it. Check that the code was entered in the Format Cells dialog’s Type box, not into the worksheet as ordinary cell text. Also check whether the cells are stored as text rather than numbers; number formats do not change text into numeric values.
- Commas or decimal points behave differently. Excel’s displayed separators can depend on regional settings. If a code copied from another locale does not work as expected, use the separators accepted by your Excel installation.
Also remember that a custom display can be misleading in exports or when data is copied into another program. The recipient may see the full stored value, a formatted value, or a different representation depending on the export or paste method. If the abbreviation must be part of the actual text—for example, for a system that only accepts labels—create text deliberately and keep in mind that text is less convenient for arithmetic and sorting as numbers.
Editing or Removing the Format
To change the suffix, select the cells, reopen Format Cells with Ctrl+1, choose Custom, and edit the Type entry. To remove the custom appearance, choose an appropriate built-in category such as General or Number. This changes the display, not the underlying value. For instance, a cell showing 1.3m with a million-scaled format can return to showing 1250000 when you switch to General.
On Excel for Mac, select the cells and use Command+1 to open Format Cells; the custom-format approach is similar. In Excel for the web, available custom-format editing controls can differ from the desktop dialog. If you cannot enter or edit the code in the browser, open the workbook in the desktop app. A workbook with a custom format may still display that formatting in other Excel versions, but a different spreadsheet program may interpret it differently.
Frequently Asked Questions
How do I make Excel show 1.5m for 1,500,000? Apply the custom format 0.0,,"m" to the numeric cell. The two trailing commas scale the display to millions, and the decimal placeholder shows one digit after the decimal point. The stored value remains 1,500,000.
How do I add m without dividing by a million? Use 0"m", or #,##0"m" if you want grouping separators. These formats append the letter but do not scale the display.
Does adding m change the number in Excel? No. A number format changes the appearance of a numeric value, not the value itself. Calculations continue to use the original number. Use a formula or a separate value if you need an actual mathematical conversion.
Can I use M instead of m? Yes. Put the uppercase letter in quotes, as in 0"M" or 0.0,,"M". Whether M or m is clearer depends on your audience and the convention used in the rest of the worksheet.
Why does my value show as 0.0m? The million-scaled display may be rounding a smaller value to zero at the chosen precision. Add decimal places or use a thousands format instead. For example, values much smaller than one million may need a k suffix or the full number to remain informative.
Related
- Contacts List Template Excel: Build a Useful Workbook
- Contact List Excel Template: Free Options and Setup
- Contact List Format in Excel: Columns, Setup, and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Outlook Best Match Not Working? Fix Search ResultsIf Outlook Best Match is not working, first check the search scope and try the same query in…
- SUMPRODUCT Formula Not Working? Fix the Common CausesIf SUMPRODUCT is not working in Excel, first check that every range in the formula has the same…
- Excel Not Deleting All Selected Cells? How to Fix ItIf Excel is not deleting all the selected cells, first check whether you pressed Delete to clear their…
- Transpose Formula in Excel Not Working? FixesIf your Excel TRANSPOSE formula is not working, first check whether its output cells are clear and whether…
- XLOOKUP Excel Not Working? Fix Common Errors and CausesIf XLOOKUP is not working, first check that your Excel version supports it, then confirm the lookup and…
- Data Analysis in Excel Not Showing? Fix the ToolPakIf Data Analysis is missing from Excel’s Data tab, enable the Analysis ToolPak: in Excel for Microsoft 365…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.