Excel Number Format Dropdown: What It Does and How to Use It

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, the Number Format dropdown is on the Home tab, in the Number group; it usually displays General. Select a cell or range, open the dropdown, and choose a format such as Number, Currency, Percentage, or Short Date to change how the value appears without normally changing the value stored in the cell.

Where to find the Number Format dropdown

Open a workbook and select the cells you want to format. On the ribbon, choose Home, then look in the Number group for a box that may show General, Number, or another current format. Select its arrow to display the available formats. The selected format is shown in the box, so it is also a quick way to identify the active cell’s number format.

If the ribbon is narrow, Excel may compress the Number group or hide some controls. Maximize the window, widen it, or expand the ribbon to make the dropdown easier to locate. The dropdown is different from the small one-click buttons beside it: the percent, comma-style, and increase/decrease decimal buttons apply particular formatting directly.

You can also open the more detailed formatting controls by selecting Home > Number group dialog launcher, the small arrow at the group’s lower-right corner. On Windows, Ctrl+1 opens the Format Cells dialog for the selected cells. In Excel for Mac, the ribbon’s number-format controls are also on Home; the Format Cells shortcut is generally Control+1, though keyboard settings and Mac versions can affect shortcuts. Excel for the web has a similar number-format control on Home, but its ribbon layout can differ from the desktop app.

What the dropdown actually changes

A number format is a display instruction. It tells Excel how to present a stored value, not usually what the value is. For example, a cell containing 0.25 can display as 0.25, 25%, or a currency amount, depending on its format. The underlying number remains 0.25, which matters when you use the cell in formulas, sorting, or calculations.

There is an important distinction between formatting an existing value and entering a value with a symbol. If you type 25% into a General-formatted cell, Excel interprets that entry as 0.25. If you instead enter 25 and then choose Percentage, Excel displays 2,500%, because it formats the existing value 25 as a percentage. To display 25%, enter 0.25 before applying Percentage, or enter 25% directly.

Some entries that look numeric are stored as text instead. A number format will not turn text into a usable number: changing a text value to Currency, for instance, may leave it unchanged. This often happens with imported data, leading apostrophes, or values containing unexpected spaces. Formatting changes appearance; conversion is a separate task.

What the common format choices mean

The dropdown offers common formats for everyday spreadsheet work. The exact choices and their placement may vary slightly by Excel version, but these are the main options and their typical uses:

  • General: Excel’s default format. It displays values without a specific number-format rule and may show large or very small numbers in scientific notation.
  • Number: Displays a chosen number of decimal places and can use a thousands separator. Use it for quantities where decimal precision matters.
  • Currency: Displays a currency symbol alongside a value, often with two decimal places. Choose the appropriate currency and precision in the format settings when the defaults are not suitable.
  • Accounting: Also displays currency symbols, but aligns symbols and decimal points in a column, which can make financial tables easier to scan.
  • Short Date and Long Date: Present date values in compact or written-out forms. The exact date order and appearance can depend on regional settings.
  • Time: Displays a time value in a clock-style format, such as hours and minutes.
  • Percentage: Multiplies the displayed value by 100 and adds a percent sign. It does not multiply the stored value used in calculations.
  • Fraction and Scientific: Show numbers as fractions or in scientific notation, which can be useful for measurements or very large and small values.
  • Text: Treats subsequent entries as text rather than numeric values. Applying Text after a number is already entered does not always convert that existing value as expected.
  • More Number Formats: Opens the Format Cells dialog, where you can choose categories, set decimal places, select date and currency variants, or define a custom format.

How to apply a format and adjust its precision

For a quick change, select the cells, open the dropdown, and choose a category. To format a column of prices, for example, select the price cells and choose Currency or Accounting. To display a ratio as a percentage, select the cells and choose Percentage. Check the result before copying or sending the workbook, especially when the selected values have different scales.

For more control, open Format Cells and use the Number tab. Select a category, then adjust available settings such as decimal places, the thousands separator, or a symbol. Date formats include multiple patterns; choose one that is clear to the people who will read the workbook. A date such as 03/04/2026 can be ambiguous across regions, so a less ambiguous pattern, such as a month name, may be preferable for shared reports.

The decimal-place buttons in the Home tab’s Number group are a fast way to show more or fewer decimal places. They change the displayed precision, not the stored value. If a cell stores 4.567 and displays 4.57, a formula that references it can still use 4.567. If calculations must use a rounded value, use an appropriate rounding formula rather than relying on the display format.

Custom number formats for specific displays

When the built-in choices do not fit, choose More Number Formats and then Custom in the Format Cells dialog. A custom format can control how positive numbers, negative numbers, zeroes, and text appear. For instance, 0.00 displays two decimal places, while #,##0 displays whole numbers with a thousands separator where appropriate. A format such as 0.00;[Red]-0.00 displays positive values with two decimals and negative values in red with a minus sign.

Custom date and time formats can also make dates more readable. Common code letters include d for day, m for month, and y for year; repeated letters affect whether Excel displays a number or a padded value. For example, a pattern such as mmm d, yyyy can display a date as Mar 4, 2026. In date formats, m can represent a month or, in a time context, minutes, so context matters. Excel’s format preview helps show how the selected cell will appear.

Custom formats are presentation tools, not data-cleaning tools. A format that hides decimals or displays a suffix does not necessarily change the value. If a report needs to show units, dates, or identifiers consistently, document the format choice so other users understand what is displayed and what is stored.

Common problems and how to fix them

  • The format appears to do nothing: Check whether the cell contains text rather than a number or date. Imported values may need conversion before number formatting can affect them.
  • A date displays as a number: Excel stores dates as serial numbers so it can calculate with them. Apply a date format to display the serial as a calendar date. If the value does not become a sensible date, inspect the source data and regional interpretation.
  • Percentages look 100 times too large: The cell may contain 25 rather than 0.25. Percentage formatting displays the stored value multiplied by 100; it does not infer the intended scale.
  • Numbers show as ####: The column may be too narrow for the formatted value. Widen the column or choose a shorter display format. In some date or time cases, a negative value can also cause hash marks.
  • Leading zeroes disappear: Excel treats entries such as 00127 as numbers and normally drops the leading zeroes. For identifiers such as postal codes, use Text before entering the data or apply a custom display format with the required zero placeholders. Keep in mind that an identifier is often better stored as text because it is not a quantity for arithmetic.
  • Changing the format does not change a calculation: That is normally expected. Formatting changes the display, while formulas use the stored value. Use a formula or data conversion when the underlying number itself must change.

Number format versus cell style and formula text

The Number Format dropdown is not the same as a cell style. A cell style can bundle several kinds of appearance settings, such as font, fill, borders, and number formatting. Use the dropdown when you want to change the way values display without changing the rest of the cell’s design; use a style when you want a coordinated set of visual choices.

It is also distinct from the TEXT function. A number format keeps the cell’s value numeric, which is usually preferable for calculations. A formula using TEXT returns formatted text, which can be useful for creating a label but may not behave like a number in later calculations. For example, a numeric date formatted in the cell can still be compared as a date, while a date converted to text is a character string. Choose formatting for presentation within cells, and convert to text only when a text result is actually needed.

Frequently Asked Questions

Where is the Number Format dropdown in Excel?
On the Windows desktop version, open the Home tab and find the Number group. The dropdown usually shows General or the selected cell’s current format. Click its arrow to see the format choices.

How do I make Excel show two decimal places?
Select the cells, open the Number Format dropdown, and choose Number, then set the decimal places if needed through More Number Formats. The increase and decrease decimal buttons in the Number group can also adjust the displayed precision quickly.

Does changing a number format change the value?
Usually, no. It changes how Excel displays the stored value. Percentage formatting is a common source of confusion because it shows a value such as 0.25 as 25%, while the underlying value stays 0.25.

Why does Excel show a date as a five-digit number?
Excel stores dates as serial numbers that support date calculations. Apply a date format using the dropdown. If the result is still incorrect, the entry may be text or may have been interpreted using a different regional date order.

Can I add a format that is not in the dropdown?
Yes. Open More Number Formats, choose Custom, and enter a suitable format code. Custom formats change the display and do not, by themselves, change the cell’s underlying value.

How do I keep leading zeroes in a code or postal code?
Store the entry as text, or apply a custom number format with zero placeholders when the value is numeric and needs a fixed display width. For identifiers that are never used in arithmetic, text is usually the clearer choice.

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.