To display Excel values in thousands with a K suffix, select the cells, open Format Cells, choose Custom, and enter #,##0,"K". The format changes how a number appears—not the stored value—so 1250000 displays as 1,250K and still works as 1250000 in calculations.
What K means in an Excel number format
In reports and dashboards, K is a compact way to label thousands: 25K means 25,000. Excel does not have a special built-in “K” number format that automatically converts values. Instead, a custom number format combines a scaling comma, which tells Excel to display the number divided by 1,000, with the literal letter K.
The letter is a label, not a unit conversion. For instance, formatting 2500 as 2.5K does not convert dollars to thousands of dollars, nor does it change the underlying amount. It is simply a shorter presentation of the same number. K is commonly used in financial summaries, sales tables, and charts, but whether readers interpret it as thousands of dollars, units, or something else depends on the column heading and surrounding labels.
How the scaling comma works
In a custom number format, a comma placed immediately after the final digit placeholder scales the displayed number down by a factor of 1,000. A second trailing comma scales it down by a factor of 1,000,000. The comma inside a pattern such as #,##0 has a different job: it adds thousands separators to the displayed number. Position is what matters.
#,##0,"K"scales by 1,000, rounds to a whole displayed thousand, and adds K.#,##0.0,"K"scales by 1,000, shows one decimal place, and adds K.#,##0.0,,"M"scales by 1,000,000, shows one decimal place, and adds M for millions.#,##0does not scale the value; it only adds digit grouping and removes decimal places from the display.
The quotation marks tell Excel to treat K or M as literal text rather than as part of the formatting syntax. Using uppercase K is conventional in many business reports, but a quoted lowercase k can also be displayed. The choice of letter does not affect the scaling.
Apply a K format in Excel for Microsoft 365
In Excel for Microsoft 365 on Windows, apply the format through the Format Cells dialog:
- Select the cells you want to format. You can select a whole column or a specific range.
- Press Ctrl+1 to open Format Cells.
- On the Number tab, select Custom in the Category list.
- Enter
#,##0,"K"in the Type box, then select OK.
You can replace the code with one of the decimal or negative-number patterns below. On Excel for Mac, select the cells and press Command+1 to open Format Cells; then use the Number tab and Custom category. The exact dialog layout can differ slightly by platform, but the custom format code works the same way. To remove the custom display later, reopen Format Cells and choose an ordinary number format such as General or Number.
Choose how much precision to show
The right number of decimal places depends on how precise the reader needs the report to be. With #,##0,"K", 1250000 appears as 1,250K, while 1250 appears as 1K. Excel rounds the display to the chosen precision; it does not truncate the value. This is convenient for a high-level summary, but it can hide meaningful differences when values are close together.
For one decimal place, use #,##0.0,"K". With that format, 1250000 displays as 1,250.0K, and 1250 displays as 1.3K. Two decimal places can be useful for small values or a detailed comparison: #,##0.00,"K" displays 1250 as 1.25K. More decimal places preserve more visible detail but make a table wider and less compact.
Rounding can change the impression a reader gets. For example, a value of 1499 with no decimal places displays as 1K, even though it is much closer to 1.5K than to 1K. A value of 1500 displays as 2K at whole-thousand precision. If that amount of rounding would be misleading, show one decimal place, show the original value, or add a note that values are rounded.
Show K for thousands and M for millions
A column may contain values ranging from a few hundred to several million. Applying a single K format to the whole range is consistent, but very large figures can become long—for example, 12500000 becomes 12,500K. A custom format can use conditions to show millions as M, thousands as K, and smaller values without a suffix:
[>=1000000]0.0,,"M";[>=1000]0.0,"K";0
In that pattern, 1250000 displays as 1.3M, 125000 displays as 125.0K, and 850 displays as 850. The format uses two conditional sections and a fallback section for other numeric values. Because this version shows one decimal place for both K and M values, 1250 appears as 1.3K. Check small, large, and negative examples in your own data before applying it to a report; a single scale may be easier to understand when readers need to compare every figure directly.
Excel custom number formats can have up to four sections separated by semicolons: positive numbers, negative numbers, zero, and text. Conditions can be used in the first two sections, as in the example above. If the display rules are becoming difficult to explain, separate columns or a clearly labeled chart may be more readable than an elaborate format code.
Control negative values, zero, and text
A basic K format applies to positive and negative numbers and zero. If you want to control those displays separately, use four sections. For example, #,##0,"K";-#,##0,"K";0;@ displays positive values with K, negative values with a minus sign and K, zero as 0, and text as entered. The semicolons separate the sections in that order. If you prefer zero to display as a dash, replace the third section with a quoted dash: #,##0,"K";-#,##0,"K";"-";@.
These patterns affect appearance, not cell contents. A text entry such as “1250000” may not behave like the numeric value 1250000, and a numeric custom format will not scale text as a number. If a cell does not display as expected, check whether the value is actually stored as a number. Also ensure that the cell has not been assigned a different format that overrides your intended display.
Number formatting versus formulas
A common alternative is to divide the value by 1000 in a formula and append K with a text function. That approach creates a text result, which can be less convenient for sorting, charting, arithmetic, or later calculations. A custom number format keeps the cell numeric, so formulas that refer to it continue to use the full stored value.
For example, if a cell contains 1250000 and is formatted to display 1,250K, a sum still includes 1250000—not 1250. This is usually the preferred choice when the number is still data that people may calculate with. A formula-generated label can make sense when the goal is to create a fixed text string for an export or a sentence, but it should not be confused with a numeric value.
Formatting also does not change the value shown in the formula bar when the cell is selected, and it does not determine the precision of calculations. Excel stores and calculates with the underlying value, subject to the workbook’s calculation settings. If you need to permanently round or rescale data rather than merely shorten its display, that is a data or formula decision, not a number-format change.
Common K-format problems
- The number is not divided by 1,000: Check that the comma comes after the final digit placeholder and before the quoted suffix. A grouping comma inside
#,##0is not a scaling comma. - The letter K is missing or causes an error: Put the suffix in quotation marks, as in
"K". Quoting literal text makes the format code explicit. - Small values show as 0K: The format has rounded the scaled value to zero. Use one decimal place, or do not scale that range.
- Values look rounded incorrectly: The displayed precision may be too low. Increase the decimal places or inspect the full value in the formula bar.
- Only some cells change: Check the selected range and whether the cells contain numbers rather than text. Also inspect any separate number formats applied to other cells.
- A chart label does not match the cell: Chart labels may use their own number-format settings. Check the chart’s data-label formatting rather than assuming the worksheet cell format controls every label.
Regional settings can affect how Excel displays decimal and grouping separators. A workbook may show a decimal comma or a different grouping character depending on the system or Excel settings, even when the underlying custom format uses familiar examples such as #,##0.0,"K". If you share a workbook, review how the format appears on the recipient’s system.
When a K format is useful—and when it is not
K formatting works well in compact summaries, management dashboards, and chart labels where readers need the overall scale rather than every digit. It can also make adjacent values easier to scan by avoiding long strings of zeros. Keep the unit clear: a heading such as “Revenue ($K)” tells readers that displayed figures are thousands of dollars, while “Orders (K)” indicates thousands of orders.
A K display may be a poor choice for invoices, transaction-level data, small samples, or any situation where exact amounts matter. It can also complicate comparisons if one report uses K and another uses full values without explaining the scale. When a value’s exact amount matters, show the full number or provide a clear note and an accessible way to inspect the underlying value.
Frequently Asked Questions
What is the Excel format code for thousands with K?
Use #,##0,"K" for whole displayed thousands, or #,##0.0,"K" for one decimal place. Apply it from Format Cells > Number > Custom.
Does adding K change the value in the cell?
No. A custom number format changes only the display. A cell containing 1250000 still contains 1250000 and remains numeric for calculations.
Why does 999 display as 1K?
The format divides the displayed number by 1,000 and rounds to a whole number. Use a decimal place, such as #,##0.0,"K", or leave smaller values unscaled if that rounding is unsuitable.
How do I show millions as M instead of thousands as K?
Use two trailing commas to scale by one million. For example, #,##0.0,,"M" displays 1250000 as 1.3M.
Can I use lowercase k?
Yes. Replace the quoted suffix with "k" if that matches your preferred style. The letter’s case does not alter the number-format scaling.
Related
- Excel Formatting Keyboard Shortcuts: A Practical Guide
- Excel Keyboard Shortcuts to Change Sheets in a Workbook
- Excel Zoom In Shortcut: The Keyboard Method
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create Email Rules in New Outlook: A Step-by-Step GuideTo create an email rule in New Outlook, open Settings, go to Mail > Rules, select Add new…
- How to Double Space in Word: Steps, Tips, and FixesTo double-space text in Word, select it and choose Home > Line and Paragraph Spacing > 2.0. To…
- How to Find Duplicate Values in Excel: Step-by-StepTo find duplicate values in Excel, select the cells you want to check, then choose Home > Conditional…
- Excel ODS vs CSV: Which Format Should You Use?ODS and CSV are different spreadsheet file formats: use ODS when you need to keep a workbook’s sheets,…
- Hanging Indent in Word: Shortcuts, Setup, and FixesIn Microsoft Word for Windows, press Ctrl+T to create or increase a hanging indent in the paragraph containing…
- Clear Email Address Cache in Outlook: Step-by-StepTo clear Outlook’s remembered email addresses, remove individual suggestions with the X beside them, or, in classic Outlook…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.