Display Values in Thousands or Show Three Zeros with Excel Number Formatting
Question details
The user wants to choose an Excel custom number format for displaying values in thousands or showing three zeros.

- 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.
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.
Display Excel Values in Thousands
Use a trailing comma in a custom format to scale the displayed value by 1,000.
Select the numeric cells, right-click the selection, and choose Format Cells.
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.
Click OK. For example, 1234567 displays as 1,235; the stored value remains 1234567.

Show Three Digits or Three Literal Zeros
Use 000 to pad a number to at least three digits, or use a quoted format to display the same three zeros for every numeric value.
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. Open the spreadsheet: Open your workbook in WPS Spreadsheet and select the numeric cells you want to format.
- 2. Open Format Cells: Right-click the selection and choose Format Cells, then select Custom under the Number settings.
- 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. Apply and save: Click OK, check the displayed values, and use File > Save to save the workbook.

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.




