Forum Discussion
Filter no choice between number and text
In a table when I put in a filter and I want a number filter EXCEL automatically puts in a text filter and I want a number filter. EXCEL Does not give me a choice. There are blank cells in the column...
It is my understanding the if more numbers show up in the column then ,"", text responses EXCEL automatically makes the number filter show. The problem comes if the "" text response is the larger then EXCEL automatically chooses the text filter and you don't have a choice. Then you must make your answer in all of the cells in the column numeric. That creates other problems when you say average the numbers in the column.
skylanetk You wrote:
It is my understanding the if more numbers show up in the column then ,"", text responses EXCEL automatically makes the number filter show. The problem comes if the "" text response is the larger then EXCEL automatically chooses the text filter and you don't have a choice. Then you must make your answer in all of the cells in the column numeric. That creates other problems when you say average the numbers in the column.
But my column--the one from which my image of the filter dialog box was taken--has more cells with the "" value than with a numeric value. Yet it's still showing as it is pictured. It's possible we're working with different versions of Excel, I suppose. Mine is the most recent version.
- I am a Microsoft office user also, Microsoft 365.