Change Text Filter to Number Filter in Excel?

Formulas & functions · Updated November 19, 2026

To change a Text Filters menu to Number Filters in Excel, convert the values in that column from text to real numbers, then refresh the filter. Excel chooses the filter commands according to the data it recognizes; changing a cell’s display format to Number alone does not convert text-stored digits.

Why Excel shows Text Filters instead of Number Filters

An Excel filter is attached to a column, but the available conditions depend on the kind of data Excel detects in its cells. For a numeric column, its dropdown can offer options such as Greater Than, Less Than, and Between under Number Filters. For a text column, it offers text conditions such as Begins With or Contains. Date columns have their own date-filter options.

A value can look like a number without being stored as one. For example, a cell containing 125 may actually hold the text string 125. This can happen when someone imports a CSV file, pastes data from a website, adds an apostrophe before a value, or brings data in from another system. A left-aligned value or a small warning icon may suggest that Excel has stored a number as text, but alignment is not definitive because formatting can change it.

Changing the number format does not repair the underlying type. Selecting Home > Number Format > Number may make a real number display with decimals, but it does not turn text into a numeric value. The conversion must happen first; the number format controls only how a numeric value appears.

Convert text-stored numbers using Excel’s warning

For a small group of cells, Excel’s built-in conversion is usually the simplest approach. In Microsoft Excel for Microsoft 365 on Windows, look for a green error indicator in a cell containing a number stored as text. Select the affected cell or range, open the warning icon that appears, and choose Convert to Number. The warning may not appear for every kind of imported or mixed data, so use another method if the command is unavailable.

  1. Select the cells that should contain numbers, not the entire worksheet.
  2. Open the error-checking menu beside a flagged cell.
  3. Choose Convert to Number, then check a few converted values.
  4. Open the column’s filter dropdown again and look for Number Filters.

Converting a whole range at once is convenient, but check for text labels, blank cells, and identifiers before applying it. A column containing both values such as 25 and labels such as Pending is not a clean numeric field. Consider separating those kinds of information into different columns rather than forcing every entry into a number.

Convert a column with Text to Columns

For a larger set of imported values, Text to Columns can ask Excel to interpret the selected entries as general data and convert numeric text. First, make a copy of the column if the original values are important. Select the cells, go to Data > Text to Columns, and follow the wizard. Choose Delimited or Fixed width as appropriate, proceed to the column-format step, select General, and click Finish. Check the results before removing the original data.

This method is useful for a column whose entries are consistently numeric text, but it is not a universal cleanup tool. In the wizard, delimiters can split values if the settings do not match the data, and locale conventions can affect how decimal points and thousands separators are interpreted. Review a few results, especially if the source uses a different regional number format. For example, a value written with a comma as the decimal separator may be interpreted differently depending on Excel’s settings.

In Excel for Mac, the Text to Columns command is also on the Data tab, though the dialog layout can vary slightly by release. Excel for the web has a different set of available data tools; if the command or conversion choices are missing, open the workbook in the desktop app to use the Windows or Mac workflow.

Use a formula when the data needs cleanup

A formula can convert text numbers into a separate helper column, which preserves the original imported values until you have checked the results. With text-formatted values in A2:A4 containing 12, 35, and 8, enter this in B2 and fill it down:

=VALUE(A2)

The formula returns the numeric value 12 for the example in A2; filling down returns 35 and 8 for the other two rows. You can then filter the helper column using Number Filters. When the results are correct, copy the helper cells and use Paste Special > Values if you want to replace formulas with fixed numbers. Keep the source column until you have verified the conversion.

VALUE works when Excel can interpret the text as a number. It may not fix values containing unusual spaces, extra characters, or separators that do not match the workbook’s regional settings. If conversion returns an error, inspect the original text rather than assuming the filter itself is broken. Remove unwanted characters carefully, and preserve a copy before bulk editing.

Apply the numeric filter and refresh it

After conversion, open the filter dropdown in the column header and choose Number Filters. Select the condition you need, such as Greater Than, Less Than, Between, or Top 10, enter the comparison value or values, and confirm. The exact options can depend on the kind of data in the column. For instance, Greater Than 100 keeps numeric values above 100; it is not the same as a text condition that looks for characters in a string.

If the worksheet is not already filtered, click a cell in the data range and choose Data > Filter. Excel adds dropdown arrows to the header row. For an Excel table, filter arrows are typically already present in its header. Keep each column’s header distinct and avoid blank rows within a plain data range, because an incomplete selection can cause Excel to treat only part of the data as the filter range.

If you converted values while a filter was already in place, refresh the filter using Data > Reapply. You can also turn filtering off and back on with Data > Filter. Check that the filtered results make sense and clear the filter when you want to see all rows again. Filtering hides rows; it does not delete them.

Check whether Excel recognizes the values as numbers

When the expected menu still does not appear, test a sample cell rather than relying only on its appearance. With a suspected value in A2, enter this formula in another cell:

=ISNUMBER(A2)

If A2 contains the numeric value 125, the result is TRUE. If it contains the text string 125, the result is FALSE. This check can reveal a type problem even when the two cells look identical. It is a diagnostic check, not a conversion: it reports what Excel currently recognizes.

Mixed columns can be confusing. A field may contain genuine numbers, text numbers, blanks, and labels. Excel may expose commands based on the values it detects, and a filter dropdown can include choices that do not behave as expected for every row. Make the column consistent when possible. If a number filter is available but particular rows do not respond as expected, investigate those cells’ underlying values and any existing filter criteria.

Common causes of failed conversions

Invisible characters and formatting differences are frequent sources of trouble. A value copied from a web page may contain a nonbreaking space, while a CSV import may include a currency symbol, a thousands separator, or a leading apostrophe. Those characters can prevent Excel from interpreting the entry as a plain number. Do not remove punctuation automatically: a comma or period may be a meaningful decimal or thousands separator in the source data.

  • Extra spaces: Inspect a few cells and remove spaces only when they are not meaningful parts of the source.
  • Regional separators: Confirm whether the source uses a comma or period for decimals before converting.
  • Mixed content: Separate labels such as N/A or Pending from the numeric field, or decide how those entries should be handled.
  • Old filter criteria: Choose Data > Reapply or clear and reapply the filter after conversion.
  • Display formatting: Remember that Number format changes appearance, not whether text is stored as a number.

Formatting can also make a real number look surprising. A date, for example, is stored by Excel as a serial number but is normally presented with date-specific formatting and filter options. Do not convert a date column to ordinary numbers merely to get Number Filters unless you actually intend to filter the underlying serial values.

When a column should stay as text

Not every digit-only entry should become a number. Postal codes, telephone numbers, product codes, and account identifiers are often labels, not quantities. A postal code such as 00715 must retain its leading zeros; converting it to a number can reduce it to 715. Long identifiers can also lose precision because Excel supports only 15 significant digits for numeric values. Keep these fields as text and use Text Filters when filtering their characters or exact codes.

A useful question is whether arithmetic makes sense for the field. You might add sales amounts or compare measurements with Greater Than. You would not normally add postal codes or phone numbers. If the values identify records rather than measure quantities, text is generally the appropriate type even when every character is a digit.

Frequently Asked Questions

Can I change Text Filters to Number Filters without converting the cells?
No. The menu reflects the data Excel recognizes. If the entries are stored as text, convert them to numeric values first; changing their display format alone is not enough.

Why does Excel still show Text Filters after I choose Number format?
Number format changes how values display, not their underlying type. Use Convert to Number, Text to Columns, or a helper formula such as VALUE, then reapply the filter.

Will converting text to numbers remove leading zeros?
It can. Numeric values do not preserve leading zeros as part of the value, so codes such as 00715 may become 715. Keep identifiers as text if those zeros matter.

How do I filter numbers greater than a value?
Open the dropdown in the numeric column, choose Number Filters > Greater Than, enter the cutoff, and confirm. If Number Filters is missing, check whether the values are actually numeric.

Does filtering delete the rows that do not match?
No. A filter hides rows that fail the condition; it does not remove them. Clear the filter to display the full list again.

Why is a number filter option missing for only some imported data?
The column may contain a mixture of numeric values and text-stored digits, or Excel may not recognize characters and separators in the imported values. Check representative cells with ISNUMBER and clean or convert the intended numeric entries.

Related

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

More in Formulas & functions

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

Spotted an error in this guide? Let us know.