+ Reply to Thread
Results 1 to 3 of 3

Filer via 'Text Filter' not 'Number Filter'

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Filer via 'Text Filter' not 'Number Filter'

    Attached are two files (WS Test & SS Test) which are basically the same file. I created SS Test by taking WS Test and deleting the data and re-populating it. When I tried to use it I discovered that the Filter on the "Division(s)" column in SS Test says "Number Filter" but the same column in WS Test says "Text Filter".
    How do I get the "Text Filter" in SS Test?
    Attached Files Attached Files
    "Laugh? I thought I'd die!"

    Jimbo?

  2. #2
    Registered User
    Join Date
    07-09-2013
    Location
    Oshawa, Canada
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Filer via 'Text Filter' not 'Number Filter'

    Sure is weird... I could only change the filter to text by forcing the cells to be text by typing ' before the data, ie '5400.

  3. #3
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: Filer via 'Text Filter' not 'Number Filter'

    I found a work around. I was able to cut and paste names and ratings, and then went back and manually typed in the division numbers. I also put the " ' " before the 0 for the first entry and the filter type stayed at "Text". Still very confusing, but it works.

    thanks for the suggestion!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is there a way to filter by color and text or number?
    By woshichuanqilz in forum Excel General
    Replies: 1
    Last Post: 04-26-2017, 10:29 AM
  2. [SOLVED] I need formula or macro to filter a number of items from different tables at single filter
    By Karthikeyannb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2014, 11:04 AM
  3. Filter Feature has Text Filters, but I want number filter
    By 6string in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 06-09-2014, 02:57 PM
  4. [SOLVED] Filter Table as i type in textbox1 but when erasing the text filter should be unfilter
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2014, 09:08 AM
  5. [SOLVED] Filter by number preceding text
    By kimberwarden in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2014, 02:14 PM
  6. Place a number filter on a report filter in a pivot table
    By reuben.doetsch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2010, 12:41 PM
  7. text and number filter
    By surgical in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2008, 10:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1