Excel Number Format Box: Find, Use, and Fix Formats

Errors & fixes · Updated November 20, 2026

The Number Format box in Excel is the dropdown on the Home tab that usually displays General; use it to change how selected cell values appear, such as as dates, percentages, currency, or decimal numbers. Select the cells, open the dropdown in the Number group, and choose a format; the stored value generally stays the same.

What the Number Format box does

Excel separates a cell’s underlying value from the way that value is displayed. The Number Format box controls the display: a value such as 0.25 can appear as 0.25, 25%, or a currency amount, depending on the chosen format. The formula bar or a formula that refers to the cell can still use the underlying value.

The box is often called the Number Format dropdown or number-format selector. It is not a place to type a number or formula. Its current label reflects the selected cell or range; for example, it may show General, Date, or Percentage. If a selection contains cells with different formats, Excel may show a blank or mixed indication rather than one clear format.

Formatting is useful for making data easier to read and compare. It does not normally convert a number into text or change the result of a calculation. There are exceptions to keep in mind: applying a percentage format scales the displayed number by 100, and applying a date format to an ordinary number makes Excel interpret that number as a date serial for display.

Where to find it in Excel

In Excel for Microsoft 365 on Windows, select one or more cells, open the Home tab, and look in the Number group. The box is the dropdown near the number-style buttons; it commonly displays General when the selected cells have the default format. Click its arrow to see the built-in choices. The neighboring buttons for currency, percentage, and decimal places can apply or adjust formats too.

To see more controls, open the dialog with Ctrl+1 on Windows. On the Number tab of Format Cells, the Category list offers the same broad families of formats, while the options on the right let you set details such as decimal places, negative-number appearance, or a date type. You can also reach this dialog from the Number group’s dialog launcher, the small arrow at the group’s lower-right corner.

In Excel for Mac, the Number Format dropdown is also on the Home tab. The Format Cells dialog is available from Format > Cells; keyboard shortcuts can differ with the keyboard and Excel settings. Excel for the web has a Home-tab number-format control as well, though the layout and available dialog options may vary slightly from the desktop app.

How to apply a format

For a basic change, select the cells first, then choose a format from the dropdown. Check a few representative cells afterward, especially if the range contains dates, large values, or numbers with leading zeros. A format can be applied to a whole column or range before data is entered, which helps keep later entries consistent.

  1. Select the cell, range, or column you want to format. To select a full column, click its column letter.
  2. On the Home tab, open the Number Format dropdown in the Number group.
  3. Choose a suitable type, such as Number, Short Date, Percentage, or Currency.
  4. If the built-in choice needs adjustment, open Format Cells and set its options, or use Custom to enter a format code.
  5. Review the displayed result and, when relevant, check the formula bar to distinguish display from stored value.

For example, selecting a cell containing 0.4 and choosing Percentage displays 40%. If the cell contains 40 instead, choosing Percentage displays 4000%. That result is not a calculation error: Excel is showing the stored value as a percentage. If you meant forty percent, enter 40% or enter 0.4 before applying the format.

Choosing among common number formats

Pick a format based on what the values mean and what readers need to compare. The dropdown’s built-in choices cover many everyday cases, but a sensible format should preserve useful precision and avoid implying a unit or meaning that the data does not have.

  • General: Excel’s default display. It shows values in a general-purpose way and may use scientific notation for very large or small numbers.
  • Number: Useful for quantities where decimal places and thousands separators matter. In Format Cells, you can choose the number of decimal places and how negative numbers appear.
  • Currency and Accounting: Both show monetary values with a currency symbol. Accounting aligns symbols and decimal points in a column, while Currency places the symbol closer to each amount.
  • Percentage: Shows a proportion as a percent. A stored value of 0.075 displays as 7.5% when one decimal place is shown.
  • Date and Time: Change how Excel displays date or time serial values. A date may appear as 3/4/2026 or as a longer written date, depending on the selected style and regional settings.
  • Text: Treats entries as text rather than ordinary numeric values. It is useful for codes and identifiers, but applying Text after a number has already been entered does not necessarily restore digits Excel discarded.
  • Scientific and Fraction: Show values in scientific notation or as fractions when those presentations suit the data.

Custom formats and useful examples

If none of the built-in styles is quite right, open Format Cells and choose Custom. Type a format code in the Type field and confirm it. The code changes the display, not the underlying number. For example, 0.00 displays two decimal places, while #,##0 displays whole numbers with a thousands separator where appropriate. The comma and decimal conventions shown can depend on regional settings.

In custom codes, 0 is a digit placeholder that displays a zero when no digit is present; # displays a digit only when needed. Thus 00000 can display the number 73 as 00073. This is useful for a fixed-width code, but it does not make the value a text identifier. If an identifier must retain leading zeros for export or matching, store it as text from the start.

Custom number formats can have sections separated by semicolons for positive values, negative values, zero, and text, in that order. For instance, #,##0.00;[Red](#,##0.00);- displays positive values with two decimals, negative values in red parentheses, and zero as a dash. Color names and format syntax are subject to Excel’s supported format-code rules. Test a custom code on sample values before applying it to a large report.

For dates, yyyy-mm-dd is a clear year-month-day presentation, while m/d/yyyy is a compact month/day/year style in a typical U.S. locale. Date codes can be interpreted differently across regional settings, so check the result when sharing a workbook internationally. A format code does not change the date’s underlying serial value.

Display format versus stored value

A frequent misconception is that changing a number format rounds or edits the actual value. If a cell stores 12.678 and Number format displays two decimal places, the screen may show 12.68, but calculations can still use 12.678. To change the value itself, use a rounding formula or edit the entry; formatting alone is not rounding.

Dates illustrate the distinction particularly well. Excel stores valid dates as serial numbers and applies a date format to show them in a calendar-like form. If a date-formatted cell is changed to General, it may display a serial number. Conversely, formatting an ordinary number as a date can make it look like a date even when that was never its intended meaning.

Formatting also does not add a currency conversion, tax calculation, or unit conversion. A currency symbol is a visual label. If a workbook contains amounts in different currencies, changing the format does not convert those amounts; the conversion must be calculated separately using an appropriate exchange rate.

Common problems and how to fix them

  • A date appears as a number: Select the cell and choose an appropriate Date format. If the value is not a valid date serial, changing the display style will not turn it into a meaningful date.
  • A number displays as scientific notation: Try Number or a custom format with enough digit placeholders, and widen the column. Excel’s General display may use scientific notation when a value does not fit the available space.
  • Leading zeros disappear: For future entries, format the cells as Text before typing, or enter an apostrophe before an identifier. A custom zero format can show leading zeros for numeric display, but it does not preserve an identifier as text.
  • Percentages look 100 times too large: Check the stored value. Formatting 25 as a percentage displays 2500%; a stored value of 0.25 displays 25%.
  • Cells show ####: The column may be too narrow for the formatted value, especially for dates or negative numbers. Widen the column or choose a shorter display format; the hashes do not usually mean the value has been erased.
  • Formatting seems not to work: Check whether the cell contains text rather than a number, and inspect the formula bar. Also check whether a conditional formatting rule is overriding the appearance. Select the cells and use Home > Conditional Formatting > Manage Rules to review relevant rules.

Be cautious with long numeric identifiers such as account, product, or tracking numbers. Excel preserves only 15 significant digits when storing numeric values, so a longer identifier entered as a number may lose precision. Set the cells to Text before entry or import the column as text; changing the number format afterward cannot recover digits already lost.

Other ways to format cells

The Number Format box is quick for common choices, but it is not the only route. Ctrl+1 on Windows opens Format Cells, which is better when you need decimal-place settings or a custom code. The ribbon’s decimal-place buttons can increase or decrease displayed decimal places without opening the dialog. These buttons change the number format, not the stored value.

You can also copy formatting with Format Painter on the Home tab. Select a cell with the desired appearance, click Format Painter, and then select the destination cells. This can copy more than number formatting, so use it carefully if the source cell also has a fill, border, or font style you do not want to transfer. To remove formatting while keeping cell contents, use Home > Clear > Clear Formats.

For a one-off display that should not change the cell’s format, a formula or a separate text column may be more appropriate, but that creates text output rather than a numeric value in many cases. Keep values numeric when you need arithmetic, sorting, or charting; use formatting for presentation and reserve text for labels and identifiers.

Frequently Asked Questions

Where is the Number Format box in Excel?
On Windows, select cells and go to Home > Number. The dropdown that commonly says General is the Number Format box. Excel for Mac and Excel for the web also place number-format controls on the Home tab.

Does changing the number format change the value?
Usually, no. It changes how Excel displays the value. Calculations continue to use the stored value, even if the format hides decimal places or adds a currency symbol.

How do I open Format Cells?
In Excel for Microsoft 365 on Windows, select the cells and press Ctrl+1, or use the dialog launcher in the Number group. On Mac, use Format > Cells if the keyboard shortcut is not suitable.

Why does Excel show a date as a number?
Excel stores dates as serial values and uses a date format to display them as dates. If the cell is set to General or Number, the serial may be visible; apply a suitable Date format to show a calendar date.

How can I keep zeros at the beginning of a number?
For a visual fixed-width number, use a custom format such as 00000. For an ID that must retain those zeros as part of its actual text, format the cells as Text before entering or importing the data.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.