+ Reply to Thread
Results 1 to 2 of 2

Filter does not recognize cell as a date

  1. #1
    Registered User
    Join Date
    06-23-2009
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    16

    Filter does not recognize cell as a date

    Sometimes Excel doesn't recognize my cells as dates, and doesn't give me the ability to filter by year, month, etc.

    I understand one way to fix this, is to (1) select column, (2) text to columns, (3) select date as the format. Then the filter will allow you to filter by year, month, etc.

    Is this the best way to go about getting my dates recognized as dates?

    I'd like to understand what's going on behind the scenes. Why is it being considered text in the first place, when clearly it's in a date pattern? What controls how Excel views the data?

    date filter.png

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Filter does not recognize cell as a date

    It depends where the data is coming from. If it is being pasted from another source Excel will take on the format from that source. First make sure that your worksheet is correctly formatted then try using Paste Special and select Values.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. vba does not recognize date anymore
    By Testco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-10-2013, 07:55 AM
  2. [SOLVED] Date Filter based on Cell Input - single date or range of dates
    By babaloo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2012, 10:32 AM
  3. Excel not to recognize date
    By eminthepooh in forum Excel General
    Replies: 3
    Last Post: 08-24-2009, 11:07 PM
  4. Force excel not to recognize cell as "date"
    By mittal87 in forum Excel General
    Replies: 3
    Last Post: 07-14-2009, 02:49 PM
  5. Can a cell recognize the current date and time
    By berk21 in forum Excel General
    Replies: 4
    Last Post: 02-03-2009, 04:09 PM

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