Excel Number Format Arrow: 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 arrow is the drop-down beside the format box in Home > Number; click it to choose formats such as General, Number, Currency, Percentage, or Date. If you mean the tiny diagonal arrow at the bottom-right of the Number group, that opens the full Format Cells dialog, where you can adjust number formats in more detail.

Which Number Format Arrow Do You Mean?

Excel places two controls that look like arrows in or near the Number group, so it is easy to mean one while looking for the other. The main Number Format drop-down is beside the box that usually displays General. Its menu offers common formats you can apply with a click. The small diagonal arrow, also called a dialog box launcher, sits at the lower-right corner of the Number group on the Home tab. It opens Format Cells, a dialog with more options than the quick menu.

To find either control, select a cell or range, then go to the Home tab and locate the Number group. If the Excel window is narrow or the ribbon is simplified, the group may be compressed and its controls may appear differently; maximize the window or expand the ribbon to see them. Clicking the drop-down next to General changes the selected cells’ display format. Clicking the group launcher opens a dialog; it does not immediately apply a different format.

These controls are sometimes confused with the arrows used to sort or filter a table column. A filter arrow appears in a table or filtered header and controls which rows are shown. The Number Format arrow is on the ribbon and controls how selected cell values appear.

How to Use the Quick Format Menu

For a standard format, the ribbon menu is the quickest route. Select the cells first, open Home > Number’s format drop-down, then choose the option that fits the data. The chosen format applies to every selected cell, although each cell’s underlying value remains unchanged.

  1. Select one cell, a range, or an entire column. To select a range, drag across the cells or click the first cell and Shift-click the last.
  2. On the Home tab, find the Number group and click the arrow beside the format box, which may currently say General.
  3. Choose a format such as Number, Currency, Accounting, Short Date, Long Date, Percentage, Fraction, Scientific, or Text.
  4. If the result needs adjustment, use the decimal-place buttons in the Number group or open Format Cells for additional settings.

For example, if cell B2 contains the value 0.25 and you select Percentage, Excel displays 25%. The value remains 0.25, so a formula that uses B2 still works with the decimal value. If you choose Currency for 1250, Excel displays a currency symbol and decimal places according to the selected currency style and regional settings; the value remains 1250.

What the Format Cells Dialog Adds

The dialog box launcher is useful when a quick menu option is not specific enough. Click the small diagonal arrow in the Number group, or select cells and press Ctrl+1 in Windows. The Format Cells dialog opens with tabs including Number, Alignment, Font, Border, Fill, and Protection. Choose the Number tab to work with categories and their settings.

Within the Number tab, the Category list includes formats such as Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, and Custom. Available settings depend on the category. Number, for instance, lets you set decimal places, choose a thousands separator, and specify how negative numbers look. Currency and Accounting let you choose a currency symbol and decimal presentation, with Accounting aligning symbols and decimal points in a column. Date and Time offer display patterns, while Custom lets you define a format code.

When you choose a date category, the dialog may show a Locale (location) option and a list of date patterns. That can help when a workbook uses dates displayed in a particular regional style. The stored date is still the same value; the selected pattern only changes its appearance. Format Cells also includes options unrelated to number display, so make sure the Number tab is selected when you are trying to change a format.

Number Formats Change Appearance, Not the Stored Value

A number format controls how Excel displays a value, not what the cell contains. This distinction is central to avoiding spreadsheet errors. A cell displaying $1,250.00 can still contain the numeric value 1250, and a cell displaying 45% can contain 0.45. Formulas generally calculate with the underlying value, not the string shown on screen.

Dates illustrate the same principle. Excel stores dates as serial numbers and applies a date format to show them as calendar dates. If a date-formatted cell is changed to General, it may display a number rather than a familiar date. That does not necessarily mean the date has been lost; it often means the display format changed. Applying a suitable date format can show the date again.

There is an important exception in practice: formatting a cell as Text does not reliably convert a value that is already in the cell into text. It changes how Excel treats later entries, but existing numeric values may remain numeric. If you need to convert existing values to text, use an appropriate conversion method, such as Excel’s Text to Columns tool, or a formula designed for the task. Also, formatting a cell as Text before entering a value can preserve leading zeros in entries such as product codes, but codes are usually identifiers rather than numbers to calculate with.

Choosing the Right Format for Common Values

Choose a format based on what the value means and how readers need to interpret it. A format that looks attractive but hides meaningful precision can mislead. These common choices provide a useful starting point:

  • General: Use for ordinary values when you do not need a fixed display pattern. Excel may show large or precise values in scientific notation or display fewer digits than the stored value.
  • Number: Use for quantities you want to display with a set number of decimal places, optional thousands separators, and a chosen negative-number style.
  • Currency or Accounting: Use for monetary values when a symbol and consistent decimal presentation are helpful. Check that the symbol matches the intended currency; the format does not convert one currency into another.
  • Percentage: Use when the stored decimal represents a proportion. Formatting 0.08 as a percentage displays 8%; formatting 8 as a percentage displays 800%, because Excel multiplies the displayed value by 100.
  • Date or Time: Use for genuine date or time values. Select a pattern that makes day, month, and year unambiguous for the people who will read the file.
  • Text: Use for labels and identifiers that should not be calculated, especially when leading zeros matter. Avoid treating quantities as text if you need arithmetic or numeric sorting.

One helpful example is a spreadsheet of 8% discount rates. If a cell stores 0.08, Percentage displays 8%. If it stores 8, Percentage displays 800%, so simply choosing the format does not correct an incorrectly entered value. Likewise, applying a currency style to a value does not add a currency conversion or determine the appropriate exchange rate.

Custom Formats and Useful Display Patterns

When the built-in choices do not meet a need, select Custom in the Number tab of Format Cells. A custom format can change how positive numbers, negative numbers, zero, and text appear, without changing the stored number. The Type box lets you select an existing pattern or enter a format code. Excel displays an example in the dialog when a valid code is selected.

For instance, a format such as 00000 can display the number 42 as 00042. This is useful for a fixed-width identifier, but it does not turn the value into a text string or make the leading zeros part of the stored number. If the identifier must retain those zeros when exported or transferred to another system, storing it as text may be safer. Custom formats can also add labels or units to a display, but the displayed text may not be included when you copy the underlying value elsewhere.

Custom formats are powerful, but a workbook may be read by people using different regional settings or spreadsheet applications. A pattern that uses commas, periods, date components, or currency symbols can be interpreted or displayed differently across locales. For widely shared files, prefer common built-in formats where possible and test important custom formats in the environment where the workbook will be used.

Why a Number Format Might Seem Not to Work

If a selected format produces an unexpected result, first check whether the cell contains a number, a date serial, or text that only looks numeric. Numbers stored as text do not always respond like numeric values. A green triangle in the cell corner or a warning icon may indicate that Excel has detected a number stored as text. Depending on the data and the workbook, you may be able to use the warning menu to convert it to a number, but verify the result before applying calculations.

Other common causes include:

  • The wrong cells are selected: The format applies only to the current selection. Check the Name Box or click a cell in the intended range before changing the format.
  • The value was entered at a different scale: As with 8 versus 0.08 under Percentage, formatting changes appearance but does not repair the underlying value.
  • Too many digits are hidden: A format may show fewer decimal places than the value contains. Increase decimal places if the extra precision matters.
  • A column is too narrow: Excel may display hash marks for some date and numeric formats when the column cannot show the result. Widen the column or use AutoFit by double-clicking the boundary between column headings.
  • The cell uses a custom format: A custom pattern may override the appearance you expected. Open Format Cells and inspect the selected category and Type box.

Do not assume a display difference means the value changed. Select the cell and inspect the Formula Bar, or temporarily switch to General to see another representation. If the data is important, make a copy before bulk-converting text and numeric values; conversions can affect identifiers, leading zeros, and date interpretation.

Windows, Mac, and Excel for the Web

The instructions above target Excel for Microsoft 365 on Windows. On Windows, Ctrl+1 opens Format Cells for the selected cells. In Excel for Microsoft 365 for Mac, the equivalent shortcut is Command+1. The ribbon may be arranged or labeled slightly differently across platforms, but the Home tab’s number-format controls serve the same general purpose.

Excel for the web also provides number-format choices from the Home tab, though its ribbon and dialog options may differ from the Windows desktop application. Some detailed formatting features available in desktop Format Cells may be limited or presented differently in the browser. If you need a particular custom format and cannot find its controls in Excel for the web, open the workbook in the desktop application and use the Number tab in Format Cells.

Frequently Asked Questions

Where is the Number Format arrow in Excel?
Go to the Home tab and find the Number group. The main Number Format arrow is beside the box that usually displays General. It opens a menu of common number formats.

What does the small arrow in the Number group do?
The small diagonal arrow at the lower-right of the Number group opens the Format Cells dialog. Select the Number tab there to choose categories, decimal places, currency symbols, date patterns, and custom formats.

Does changing a number format change the value?
No. A number format normally changes how a value is displayed, not the underlying value used in calculations. Percentage is a common source of confusion: 0.25 displays as 25%, while 25 displays as 2,500%.

Why does Excel show hash marks after I choose a date format?
The column may be too narrow to display the formatted date. Widen the column or AutoFit it by double-clicking the boundary between its heading and the next column. If that does not help, check whether the cell contains a valid date value.

How do I keep leading zeros in an Excel cell?
For codes or identifiers, format the cells as Text before entering the values, or use a custom format such as 00000 when a fixed number of displayed digits is appropriate. A custom format changes the display; it does not make the zeros part of the underlying numeric value.

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.