Formatting Issues

Display Values in Thousands or Show Three Zeros with Excel Number Formatting

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

The user wants to choose an Excel custom number format for displaying values in thousands or showing three zeros.

Display Values in Thousands or Show Three Zeros in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is formatting numeric cells and needs to distinguish scaled thousands from a three-zero display.
Observed behavior
The desired display depends on whether the user wants a scaled value, a number padded to three digits, or the literal text 000.
Before you start

Identify the current cell value and the display you expect. For example, decide whether 1234567 should appear as 1,235 or whether 7 should appear as 007.

Solution 1Recommended

Display Excel Values in Thousands

Use a trailing comma in a custom format to scale the displayed value by 1,000.

1
Open number formatting

Select the numeric cells, right-click the selection, and choose Format Cells.

2
Enter the custom format

On the Number tab, select Custom and enter #,##0, in the Type box. The final comma is essential: it scales the displayed value by 1,000.

3
Apply and check

Click OK. For example, 1234567 displays as 1,235; the stored value remains 1234567.

Display Excel Values in Thousands
To show a decimal place: Use #,##0.0, to display one decimal place in thousands. For example, 1234567 displays as 1,234.6.
WPS Spreadsheet formatting

Format Thousands and Three-Digit Numbers in WPS Spreadsheet

Use custom number formats in WPS Spreadsheet to display values in thousands, pad numbers to three digits, or show literal zeros.

  1. 1. Open the spreadsheet: Open your workbook in WPS Spreadsheet and select the numeric cells you want to format.
  2. 2. Open Format Cells: Right-click the selection and choose Format Cells, then select Custom under the Number settings.
  3. 3. Enter a format: In the Type box, enter #,##0, for values displayed in thousands, 000 for at least three digits, or "000" for three literal zeros.
  4. 4. Apply and save: Click OK, check the displayed values, and use File > Save to save the workbook.
Display scaled thousands or three-digit numbers without changing stored valuesOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet formatting interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel format show a thousands separator but not scale the number?

The format #,##0 uses a comma as a thousands separator. Add a trailing comma, as in #,##0,, to display the value divided by 1,000.

Does formatting a number in thousands change its actual value?

No. A custom number format changes the display, not the stored value used in formulas. The displayed result may be rounded.

How can I make 7 appear as 007 in Excel?

Right-click the cell, choose Format Cells, select Custom, and enter 000 in the Type box. This format displays at least three digits.

What is the difference between 000 and "000"?

In a custom number format, 000 uses digit placeholders and pads shorter numbers with leading zeros. The quoted format "000" displays those three literal characters for any numeric value.