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...
This is what I am talking about. Sometimes I want a number filter and I do not get a choice. thank you for your response.
skylanetk So what I have had to do sometimes is change the query setting. For whatever reason sometimes the Columns will be set as Text type. If this is the case then when you query the data into your Excel spreadsheet go to the Query Tools tab on the toolbar.
1. Click Edit
2. The Power Query Editor should pop up
3. Select the columns you need to change to Number type
4. Under the Transform section on the toolbar there is a dropdown for Data Type
5. Select the type you need