Excel Format Numbers in Thousands (K)

How-to basics · Updated November 19, 2026

To show Excel values in thousands with a K suffix without changing the underlying numbers, select the cells, press Ctrl+1, choose Number > Custom, and enter #,##0,"K". For one decimal place, use #,##0.0,"K". The displayed value is divided by 1,000 for presentation, but Excel still stores the original number.

How the thousands format works

Excel custom number formats control how a value appears in a cell; they do not rewrite the value. In a format such as #,##0,"K", the comma after the final zero is a scaling comma. It tells Excel to display the number divided by 1,000, and the quoted K is a literal character to show after the result. The commas earlier in #,##0 group digits with thousands separators.

For example, if a cell contains 12500, the format #,##0,"K" displays 13K because the scaled result, 12.5, is rounded to a whole number. The cell still contains 12500. With #,##0.0,"K", the same value displays as 12.5K. This distinction matters if someone later adds the cell to a total, uses it in a formula, or copies the data into another system.

The K suffix is a common compact label for thousands in reports and dashboards. It is a display convention rather than a change of unit: a reader should understand that 13K represents approximately 13,000, not the exact amount 13. The appropriate precision depends on the purpose of the report.

Apply a custom K format in Excel for Windows

In Microsoft Excel for Microsoft 365 on Windows, apply the format through Format Cells. First select the cells or range; then use these steps:

  1. Press Ctrl+1 to open the Format Cells dialog.
  2. On the Number tab, select Custom in the Category list.
  3. Click in the Type box, enter #,##0,"K", and select OK.

You can also open Format Cells from the small dialog box launcher in the Home tab’s Number group. For one decimal place, enter #,##0.0,"K" instead. The Mac equivalent of Ctrl+1 is Command+1. Ribbon and dialog details can vary by platform and update; in Excel for the web, custom-format editing options may differ, so use the desktop app if you cannot enter the format code.

To remove the display format, select the cells and choose General in the Number Format list on the Home tab, or return to Format Cells and choose a different category. Removing the custom format reveals the original value; it does not reverse a calculation, because no calculation was performed.

Choose the right precision and rounding

Choose the number of decimal places based on how much detail readers need. Whole thousands are compact, while a decimal can help distinguish nearby values. More decimal places take up space and can suggest a level of accuracy that the source data does not support.

  • #,##0,"K" displays 12500 as 13K.
  • #,##0.0,"K" displays 12500 as 12.5K.
  • #,##0.00,"K" displays 12500 as 12.50K.

Excel rounds the displayed result to the chosen precision. It does not round the stored value. For instance, 12499 displays as 12K with no decimal places, but as 12.5K with one decimal place. If the source number is 12499.75, that full value remains available to formulas even if the cell shows only 12K. If exact values are important, include a note that figures are rounded or provide the unscaled data in a separate column.

Examples for reports and dashboards

The best format depends on the scale of the numbers and the audience. These examples show how a few common choices affect the display:

  • A sales figure of 48000 displays as 48K with #,##0,"K", or 48.0K with #,##0.0,"K".
  • A value of 1245000 displays as 1,245K with the whole-number K format. That may be useful when the report consistently expresses every figure in thousands.
  • A value of 1250000 displays as 1.3M with #,##0.0,,"M". Two scaling commas divide the displayed number by 1,000,000, and the quoted M marks millions.
  • A small value such as 450 displays as 0K with the whole-number K format. That can be misleading if readers might interpret it as zero; use decimal precision, a threshold-based presentation, or a separate note when small values matter.

Do not mix K and M labels casually within a column. A column in which some entries are 1,200K and others are 1.2M can be harder to compare than one consistent scale. If a table contains values across very different magnitudes, consider separate columns, a clear unit label, or a chart with readable axis labels.

Show negative numbers and zeros clearly

A custom format can specify separate appearances for positive numbers, negative numbers, and zero, in that order. For example, #,##0,"K";-#,##0,"K";"-" displays positive values with K, negative values with a minus sign and K, and zero as a dash. A value of -12500 appears as -13K because the format rounds to a whole thousand. If the dash could be mistaken for missing data, keep zero visible instead.

You can use parentheses for negative figures with #,##0,"K";(#,##0,"K");"-". Excel custom formats can have up to four sections for positive values, negative values, zero, and text. Keep the sections simple and test them on representative cells; a format changes appearance, so check that negative values remain easy to identify and that a dash has a clear meaning in your report.

Formatting versus dividing values by 1,000

Use a number format when you want compact labels while preserving the source values. This is usually the safer choice for a working dataset: totals, averages, lookups, and other calculations continue to use the full numbers, and you can switch back to the unscaled display at any time.

Dividing the values themselves is different. If you create a second column containing each original value divided by 1,000, that column contains smaller numbers, not just a different display. This can be useful when a data export or a chart source specifically needs values in thousands, but label the column clearly, for example “Revenue (thousands),” and avoid overwriting raw source data unless that is intentional. A cell showing 48K from a number format and a cell containing 48 with a K label may look alike, but they are not numerically equivalent.

Also remember that copying a formatted cell into a plain-text destination may carry only the displayed text, depending on the method used. A CSV file does not preserve Excel’s custom cell formatting, so it may contain the original number rather than the K display. If a recipient needs compact labels in a text export, check the exported file and agree on whether the values should remain raw or be converted for presentation.

Common problems and how to fix them

  • The number shows as 12,500K. The format may append a K without a scaling comma. Use #,##0,"K", placing the scaling comma after the final digit placeholder and before the quoted suffix.
  • The number appears too rounded. Add a decimal place with #,##0.0,"K", or choose a finer precision that suits the report.
  • A small amount shows as 0K. A whole-thousands display rounds small values to zero. Show a decimal, use a different unit, or retain a full-value column when the distinction matters.
  • The K appears as a format error or unexpected text. Check the Type box for missing quotation marks, extra characters, or a misplaced comma. Enter the code as shown and preview it on a known value.
  • The cell still behaves like a number. That is expected. The custom format changes only the display, so arithmetic and sorting use the original value.

Regional settings can affect how number formats are entered or displayed. Excel may show different decimal or grouping characters according to the computer’s regional settings. If a format entered with commas and periods does not behave as expected, check the preview in Format Cells and use the separators Excel recognizes in that installation.

Frequently Asked Questions

What is the Excel format code for thousands with K?
Use #,##0,"K" for whole thousands, or #,##0.0,"K" for one decimal place. The comma immediately before the quoted K scales the display by 1,000.

Does formatting a number as K change its value?
No. It changes only what Excel displays in the cell. Formulas still use the original number unless you separately create a calculation that divides it.

Why does 12500 show as 13K instead of 12.5K?
The format has no decimal place, so Excel rounds the scaled value of 12.5 to a whole thousand. Use #,##0.0,"K" to show 12.5K.

Can Excel show millions with M instead?
Yes. Use two scaling commas, as in #,##0.0,,"M", to display a value such as 1250000 as 1.3M. The stored value remains unchanged.

Will the K format remain in a CSV file?
No. CSV stores plain text values and does not retain Excel’s cell formatting. Check the exported data and decide whether the recipient needs the original numbers or text formatted with K labels.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.