Excel Number Format: How It Works and When to Use It

How-to basics · Updated November 20, 2026

In Excel, the Number format controls how a cell’s numeric value appears—for example, with two decimal places, a thousands separator, or a minus sign. To apply it in Microsoft Excel for Microsoft 365 on Windows, select the cells, then choose Home > Number group > Number Format dropdown > Number; this changes the display, not the stored value.

What Excel’s Number format means

A cell’s value and its number format are separate. A cell might contain the value 1250.5 but display it as 1,250.50, 1,250.5, or even $1,250.50, depending on its format. The format is a set of display instructions; it normally does not change the value used in calculations.

Excel starts many new cells with the General format. General displays numbers in a way that fits the cell and may show many decimal places or use scientific notation for very large or small values. The built-in Number format is useful when you want a more consistent numeric display, especially for quantities, measurements, or totals.

By default, selecting Number displays two decimal places. You can also choose whether to show a thousands separator and how negative values should appear. For example, 1250.5 can display as 1,250.50, while -1250.5 can display as -1,250.50 or in parentheses if you select an available negative-number style.

How to apply Number format

In Excel for Microsoft 365 on Windows, use the ribbon for a quick change or open Format Cells when you need more control:

  1. Select one cell or a range of cells. To format a whole column, click its column letter.
  2. On the Home tab, find the Number group and open the Number Format dropdown, which may currently show General.
  3. Choose Number. Excel applies the standard Number display to the selected cells.
  4. To adjust details, use Increase Decimal or Decrease Decimal in the Number group, or open the dropdown and choose More Number Formats to access the Format Cells dialog.

You can also open Format Cells with Ctrl+1 on Windows, then select the Number category and set decimal places, the thousands separator, and a negative-number style. On a Mac, Command+1 opens Format Cells in Excel; the Home tab’s number-format controls are also available. Excel for the web has a Home tab number-format dropdown, though some advanced formatting options may be more limited than in the desktop app.

To apply Number format quickly on Windows, Ctrl+Shift+1 applies a number format with two decimal places and a thousands separator. Keyboard shortcuts can vary with keyboard layout and Excel version; on Mac, use the ribbon or Format Cells dialog if that shortcut does not match your setup.

Number format, Number Style, and ribbon buttons

“Number style” is often used informally to mean the way numbers look, but it is not always the name of one specific Excel command. In the Home tab’s Number group, the Number Format dropdown offers categories such as General, Number, Currency, Accounting, Date, and Percentage. Nearby buttons can apply particular formats directly, including Percent Style and Comma Style.

Comma Style is commonly used for thousands separators and typically displays decimal places; it is not identical to choosing the Number category and configuring it yourself. The Accounting Number Format button applies an accounting-style currency display. These buttons are shortcuts to particular formatting choices, while the dropdown and Format Cells dialog provide more options.

Excel also has Cell Styles, a separate feature on the Home tab. Cell Styles can bundle number formatting with other visual properties such as font, fill, and borders. If you only want to change how a number appears, choose a number format rather than applying a whole cell style that may alter other aspects of the cell.

Choosing between Number and other formats

Choose a format based on what the value represents and how readers should interpret it. A number format is appropriate for ordinary quantities, while formats designed for money, percentages, or dates communicate meaning more clearly.

  • Number: Use for values such as units sold, distances, or test results when decimal places and separators are useful.
  • Currency or Accounting: Use for monetary values. Currency places the symbol close to the amount; Accounting aligns currency symbols and decimal points in a column, which can help financial tables scan neatly.
  • Percentage: Use for proportions. Excel displays 0.125 as 12.5% when Percentage format is applied; it does not turn 0.125 into a different underlying value.
  • Date or Time: Use when a number represents a date or time. These formats display the value as a calendar date or clock time rather than as an ordinary number.
  • Text: Use for identifiers that should be treated as characters, such as product codes or postal codes with leading zeros.

For example, a count of 1250 items might look clear as 1,250 with no decimal places. A measured length of 1250.5 might need 1,250.50 if two decimal places are important. A price should usually be shown with a suitable currency symbol, and a ratio intended for readers as a percent should be displayed as a percentage. Formatting is a presentation choice, so match it to the data and the audience.

Decimal places, separators, and negative values

Number format lets you control the number of displayed decimal places. Increase Decimal adds displayed places, and Decrease Decimal removes them. Removing displayed decimal places does not normally round away the stored value: a cell can show 1.23 while calculations still use a more precise value such as 1.2345. The formula bar can help reveal the value when you select the cell.

The thousands separator makes long numbers easier to read—for example, 1250000 can display as 1,250,000. The character used for decimal and thousands separators depends on regional settings, so another user’s Excel may show the same value with different punctuation. Avoid assuming commas and periods will appear identically on every computer.

Negative values may be displayed with a minus sign, in parentheses, or in a selected color, depending on the format option. Choose a style that is easy to distinguish and consistent across the workbook. For reports, parentheses are common in some accounting contexts, but a minus sign is often clearer in general-purpose tables.

When a custom number format helps

If the built-in choices do not give the display you need, Format Cells lets you create a custom number format. In the Format Cells dialog, select Custom and enter a format code. Custom formats can control how positive numbers, negative numbers, zero, and text appear, with sections separated by semicolons.

For instance, the custom code 0.0 displays one decimal place, while #,##0 displays whole numbers with a thousands separator. A three-section format such as #,##0.00;[Red](#,##0.00);- displays positive values with two decimals, negative values in red parentheses, and zero as a dash. The actual value remains numeric, so it can still be used in calculations.

Custom formats are helpful for presentation, but they do not insert characters into the underlying value. A format that appears to add a unit, for example, does not make that unit part of the cell’s text. If you need the displayed result as literal text for a report or export, you may need a different approach, and the resulting text will not behave like a number in calculations.

Common display problems and how to fix them

If a cell shows #### instead of a number, the column is often too narrow to display the formatted value. Widen the column by dragging its right boundary or double-clicking that boundary to AutoFit. A date or time can also show hashes if the result is negative under a date/time format. Check the value and format as well as the column width.

If leading zeros disappear, the cell is probably being interpreted as a number. Number formatting can sometimes display zeros for a fixed-width value, but codes such as postal codes and account identifiers are often better stored as text because they are labels, not quantities. Changing a cell to Text after entering a value may not restore zeros that Excel already removed; re-enter the value with the zeros or import it as text.

If a number appears rounded, first check the decimal places shown. The cell may simply be displaying fewer decimals than the stored value. If it appears as scientific notation, widen the column or apply a suitable Number format. Also remember that Excel preserves only 15 significant digits in numeric values; formatting cannot restore precision lost when a long identifier was entered as a number.

If choosing Number seems to do nothing, confirm that the cells actually contain numeric values. Numbers imported or pasted as text may stay left-aligned and resist numeric formatting. Depending on the data, convert them using the warning icon’s conversion option, Text to Columns, or a careful re-import. Check for leading apostrophes, spaces, or regional decimal separators that may prevent Excel from recognizing a value as numeric.

Frequently Asked Questions

Does Excel Number format change the value?
No. It changes the usual display, not the underlying numeric value. Calculations continue to use the stored value, including decimal places that are not currently visible.

How do I show two decimal places in Excel?
Select the cells and choose Home > Number group > Number Format dropdown > Number. The standard Number format shows two decimal places; you can adjust them with the decimal-place buttons or in Format Cells.

How do I add a thousands separator?
Select the cells and choose Number, then enable the thousands separator in Format Cells if it is not already selected. You can also use the Comma Style button in the Home tab’s Number group.

Why does Excel remove the zero at the start of a number?
Excel treats an entry such as 007 as the number 7, because leading zeros do not change a number’s value. For codes or other identifiers, store the entry as text or use a suitable fixed-width display format when numeric storage is appropriate.

Can I use Number format for percentages or currency?
You can, but Percentage, Currency, or Accounting is usually clearer when that is what the value means. Applying Percentage displays a value such as 0.2 as 20%; it does not calculate a new value from the existing one.

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.