Excel Number Filter Not Working? Find the Fix

If an Excel number filter is not working, first check whether the cells contain real numbers or numbers stored as text; then confirm that the filter covers the full data range and that no other filter is hiding the rows. In Excel for Microsoft 365 on Windows, select a cell in the data, choose Data > Filter, open the affected column’s dropdown, and use Number Filters when Excel recognizes the values as numeric.

How Excel number filters work

An AutoFilter does not simply compare what a cell looks like on screen. It evaluates the underlying value and data type in each cell. A value displayed as 125 might be the number 125, or it might be the text string “125.” The two can look identical, but Excel can treat them differently when you ask for values greater than, less than, or between particular numbers.

When a column contains recognized numbers, its filter menu normally offers Number Filters. Choose a condition such as Greater Than, enter a value, and select OK. For example, Greater Than 100 should leave numeric values such as 125 and 250 visible while hiding 100 and smaller values. The condition is exclusive: 100 itself does not pass a “greater than 100” test.

Filters hide rows; they do not delete the underlying records. A filtered result can therefore appear incomplete even though the data remains in the worksheet. This distinction matters when troubleshooting: a missing row may be hidden by a filter, a manually hidden row, or a different feature rather than removed.

Check whether the values are numbers or text

Start with a cell that should match your filter. Select it and inspect the formula bar and alignment. Numbers are usually right-aligned by default, while text is usually left-aligned, but formatting can override alignment, so this is only a clue. A green triangle in a cell may also indicate a number stored as text. The filter dropdown is another clue: if Excel offers Text Filters instead of Number Filters, it may be treating the column as text.

For a direct check, you can use the ISNUMBER function in a spare cell. With the value to test in A2, enter =ISNUMBER(A2) in B2. If A2 contains the numeric value 125, the result is TRUE; if it contains text that merely looks like 125, the result is FALSE. This test checks the actual cell value, not its visual appearance.

Text values often arrive through CSV files, copied web tables, database exports, or data pasted from another application. They may include a leading apostrophe, spaces, a nonbreaking space, a currency symbol stored as part of the text, or punctuation that does not match your regional number settings. A column can also contain a mixture: some rows are numeric and others are text. That mixture is a frequent reason a filter appears inconsistent.

Convert text numbers into real numbers

Make a copy of important data before converting a large imported column. If Excel marks cells with green triangles, select them, click the warning icon, and choose Convert to Number. The warning icon may not appear for every type of imported text, so use another method if that option is unavailable.

Use Text to Columns: Select the affected cells, choose Data > Text to Columns, keep Delimited selected, and proceed through the wizard without choosing a delimiter that would split your values. At the final step, choose General for the column format and click Finish. Check a few results, particularly if the data uses decimal or thousands separators.
Use a helper column: With the text value in A2, enter =VALUE(A2) in B2 and fill the formula down. If A2 contains the text “125,” the result in B2 is the numeric value 125. VALUE works for text that Excel can interpret as a number under the workbook’s regional settings; unusual spaces or symbols may need to be removed first.
Use Paste Special multiplication: Enter 1 in an empty cell and copy it. Select the text-number cells, choose Home > Paste > Paste Special, select Multiply, and confirm. This can convert many numeric text values at once, but test a small sample first. It is unsuitable if the cells contain nonnumeric text or if you need to preserve the original values unchanged.

After conversion, apply an appropriate number format if needed, then clear and reapply the filter. Formatting alone does not convert text into numbers: changing a cell’s format to Number may change how a real number is displayed, but it generally does not turn a text string into a numeric value.

Confirm the filter covers the entire data set

A filter can be functioning correctly while excluding rows you expected it to include. If the filter was turned on while only part of the data was selected, new rows added beyond the filtered range may not receive a dropdown or be included in the results. Blank rows or blank columns inside a data set can also interrupt Excel’s detection of a continuous range.

Click a cell in the data and inspect the header row and the top and bottom of the range. Confirm every intended column has a filter arrow and that the last record is inside the filtered area.
If the range is incomplete, turn the filter off with Data > Filter, select the complete rectangular range including headers, and choose Data > Filter again.
For a data set that will keep growing, consider selecting a cell in the range and choosing Insert > Table. Confirm that the table has headers. Excel tables usually expand to include adjacent entries as you add records, and their header dropdowns provide filtering.

Tables are useful for ongoing lists, but they are not required for filtering. If you do not want a table, a regular AutoFilter works as long as the complete range is selected. Avoid merged cells in the header row or data area; merged layouts can make a simple rectangular list harder to filter and maintain.

Look for other filters and hidden rows

Each column can have its own active condition. A number filter on Sales might show only values above 100 while a second filter on Region limits the visible rows to one region. To troubleshoot, open each column dropdown and look for a filter icon or a checked subset of items. Choose Clear Filter From [column name] in that dropdown to remove that column’s condition.

To clear filters across the current worksheet, use Data > Sort & Filter > Clear on the Windows ribbon. Then reapply the intended condition. Clearing filters does not repair text-formatted numbers; it only removes the conditions currently hiding rows. If rows remain missing after filters are cleared, check whether they were hidden manually: select the row headers around the gap, right-click, and choose Unhide.

Also check whether the data is inside a table with a filter, or whether the worksheet is protected. Protection settings can restrict changes to filtering. If Excel will not let you open or change the dropdown, check Review > Unprotect Sheet; a password may be required if the sheet was protected with one. A workbook opened read-only may also prevent changes from being saved.

Handle dates, decimals, and special cases

Excel stores valid dates as serial numbers but displays them in a date format. For a date column, use the date-related options in the filter dropdown, such as filtering by a date range, rather than treating the visible date like ordinary text. Imported dates can instead be text when their order or separators do not match the regional settings Excel expects. If a date filter behaves oddly, test a sample cell and convert the column using a method appropriate to its source format.

Decimal and thousands separators can cause similar trouble. A value written as “1.234,56” in one regional convention may not be interpreted as the same number under another convention. Text to Columns can provide advanced options for specifying decimal and thousands separators. Do not replace punctuation blindly: a comma might represent a decimal separator in one file and a thousands separator in another.

Identifiers such as postal codes, product codes, and account numbers often look numeric but are meant to be labels. If leading zeros matter, or arithmetic is not meaningful, keep them as text. A numeric conversion can turn “00125” into 125 and lose the leading zeros. In that case, Text Filters may be the correct choice; the goal is consistent and appropriate data, not making every digit-only entry numeric.

What to do when the filter still gives the wrong result

Test one simple condition on a small, known example. For instance, if a column contains 50, 100, and 125 as genuine numbers, Greater Than 100 should display only 125. If it does not, clear all active filters, verify the data range, check the cell types, and apply the condition again. This controlled check helps separate a data problem from an incorrect criterion.

Check for extra spaces or nonprinting characters in imported values. A cell may look like “125” but contain a space that prevents numeric conversion.
Check that the criteria are the kind you intend. Greater Than 100 excludes 100; Greater Than or Equal To 100 includes it.
Confirm that a sort has not merely moved the records. Sorting changes order; filtering hides rows that do not meet a condition.
If results are still confusing, copy a few values to a new blank worksheet and test them there. This can reveal whether the issue is limited to the source range, table, or worksheet setup.

On Excel for Mac, the same AutoFilter concepts apply, although ribbon placement and dialog layout can vary by release. Excel for the web also supports ordinary filtering, but some desktop data tools and conversion options may be unavailable or arranged differently. If the conversion steps are missing in the web app, open the workbook in the desktop version of Excel.

Frequently Asked Questions

Why does Excel show Text Filters instead of Number Filters?
Excel may be treating the column values as text, especially if they were imported or pasted from another source. Test a sample with ISNUMBER, convert true numeric data to numbers, and then reapply the filter. Mixed data types can also make the menu or results confusing.

Why does a number filter miss values that look correct?
The displayed value may be text, contain hidden spaces, or use decimal and thousands separators Excel does not recognize under the current regional settings. Check the underlying cell value, test the type, and verify the filter condition and complete data range.

Does changing the cell format to Number fix a number filter?
Not necessarily. Number formatting changes the display of numeric values, but it does not reliably convert text into numbers. Use Convert to Number, Text to Columns, or a helper formula such as VALUE when the text can be interpreted as a number.

Why is the filter arrow missing from some rows?
Filter arrows belong in the header row, not each data row. If an intended column has no arrow, the filter may cover only part of the range, the header may be outside it, or the layout may have a blank row or merged cells interrupting the data.

Will clearing a filter delete the hidden records?
No. Clearing a filter makes records visible again; it does not delete them. If rows remain hidden after clearing filters, check for manually hidden rows or another worksheet feature controlling visibility.

Prevent the problem in future imports

When importing recurring files, standardize the process rather than repeatedly fixing cells after they arrive. Check the import preview and column types, confirm separators and date conventions, and decide whether each field is a number, date, or text identifier. Preserve leading zeros in codes and convert only fields that need numeric comparisons or calculations.

Finally, keep a clean header row, avoid blank rows inside the list, and use an Excel table when the data will expand. These habits help Excel identify the correct range and make later filtering more predictable. If a number filter stops working, the fastest diagnosis is still the same: verify the value type, the range, and every active condition before rebuilding the worksheet.

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.