Formatting Issues

How to Display Excel Values in Thousands or as Currency with K

Bushra Parveen Sep 25, 2026 869 views

Question details

The user needs a method to visually format large numbers in Excel to display them scaled down in thousands or with a specific currency and 'k' suffix, while keeping the original numerical value intact.

How to Display Excel Values in Thousands or as Currency with K

Product: Excel
Device & OS: not provided
Scenario: Preparing financial reports or dashboards where large numbers need to be simplified and presented cleanly without cluttering the spreadsheet.
Observed behavior: Numbers are currently displayed in their full length, which reduces readability, and the user wants to apply a visual mask without changing the underlying cell data.

Before you start

Verify that the cells you intend to format contain actual numerical values, as custom number formats will not apply correctly to numbers stored as text.

Solution 1Recommended

Apply Custom Number Formatting via Format Cells

Use Excel's custom formatting rules to visually scale your numbers down by thousands and append required symbols.

Excel uses specific symbols in custom formats to control how numbers look. A comma placed at the end of a digit placeholder scales the displayed value by one thousand. Text enclosed in quotation marks can be added as a prefix or suffix.

Select the target cells

Highlight all the cells containing the large numbers you want to format.

Open the Format Cells dialog

Right-click the selected area and choose 'Format Cells' from the context menu, or simply press the 'Ctrl + 1' keyboard shortcut.

Set format to thousands

In the Format Cells window, go to the 'Number' tab and select 'Custom' in the Category list on the left. In the 'Type' box, enter #,##0, to display the values in thousands.

Add currency and K suffix

To include a currency prefix and the 'k' suffix, change the text in the 'Type' box to "$"#,##0,"k" and click 'OK' to apply the formatting.

Apply Custom Number Formatting via Format Cells

Original Values Preserved: This custom format changes only the visual display of the cells. The underlying precise values remain completely unchanged and can still be used accurately in any formulas or calculations.

WPS Spreadsheet Solution

Format Numbers Easily in WPS Spreadsheet

You can effortlessly apply these exact same custom number formatting rules using WPS Office. It provides full support for advanced spreadsheet formatting, making it simple to present professional financial reports.

1. Open your workbook: Launch WPS Office and open your spreadsheet file.
2. Open Format Cells: Select your data and press 'Ctrl + 1' to open the Format Cells window.
3. Apply the format: Navigate to the 'Custom' category and type "$"#,##0,"k" in the formatting box, then click OK.

100% compatible with Microsoft Excel custom formatting rules and .xlsx files.Identical shortcut keys and Format Cells menu interface.Free, lightweight, and fast office alternative.

microsoft office alternative - wps office

Frequently Asked Questions

How do I format numbers in millions instead of thousands?

To scale numbers to millions, you need to add two commas at the end of your custom format string. For example, use #,##0,,"M" to display 1,500,000 as 2M, or 0.0,,"M" to display it as 1.5M.

Will custom formatting affect my SUM or AVERAGE formulas?

No, custom number formatting solely affects the visual presentation of the data on your screen. Any mathematical formulas referencing those formatted cells will still use the exact, unrounded underlying numbers.

Can I apply this format conditionally for negative numbers?

Yes, Excel custom formats can handle positive and negative numbers differently. You can separate formats with a semicolon. For example, use "$"#,##0,"k";[Red]-"$"#,##0,"k" to display positive numbers normally and negative numbers in red with a minus sign.

Document & File Issues